98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Nested 'ElseIf' statements
Nested 'ElseIf' statements
Resolved · Low Priority · Version 2003
Thu 10 Mar 2011, 11:29Delegate Graeme said...
Graeme has attended:
Excel VBA Intro Intermediate course
Nested 'ElseIf' statements
Can you please advise if there is a limit to the number of 'ElseIf' statements you can nest into a single 'If' > 'End If'?
Tue 15 Mar 2011, 10:46Trainer Stephen said...
RE: Nested 'ElseIf' statements
Hi Graeme
Thanks for your question
In principle there is no limit to the number of ELSEif in an if block. I would however recommend using a Select Case block for checking a large number of multiple conditions, as this is easier to maintain and understand
Regards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Stop Formula Returning A "#DIV/0" ErrorIf a formula returns a #DIV/0 error message there is a way to avoid such results. |
