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'?
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