Nested Select Case

[AnalystDBA]

Hi everyone.

Simple question. Is it possible to nest a select case statement within another select case??

Cheers
AnalystDBA

 

[vb5prgrmr]

In VB it is possible so I would believe in VBA it would be possible also.
[tt]
Dim A As Integer, B As Integer
A = 1
B = A + 1
Select Case A
Case 1
Select Case B
Case 1
Case 2
MsgBox "Nested Select Possible"
End Select
End Select
[/tt]

Good Luck

 

[xlbo]

Just to confirm VB5's assumption - Yup - entirely possible as shown above Rgds
~Geoff~