I am stuck on what I think is a loop, or may be some kind of function that
calls a certain part of the program. Basically, I am trying to figure out
how to move from Case vbNo '#3 to Case vbNo '#2. Below is my code. Can
anyone offer a suggestion as to how to get from #3 to #2? I'm thinking it is
a loop because if a user selects 'No' two times in a row, this sequence would
be looped through two times (although there is really no point in that, that
would be the logic).

YesNo = MsgBox("Has Firm been provided with, or been advised of the
existence of a legal opinion?", vbYesNo, "Warning")
Select Case YesNo
Case vbYes
'If answer is Yes, no additional action needs to be taken...
Unload UserForm47
UserForm49.Show
Case vbNo '#1
'Insert your code here if No is clicked
YesNo = MsgBox("Does the level of the opinion rise to a 'should
level'?", vbYesNo, "Warning")
Select Case YesNo
Case vbYes
MsgBox "The level of opinion is SHOULD LEVEL!!"

Case vbNo '#2
YesNo = MsgBox("You answered no. Are you sure?", vbYesNo,
"Warning")
Select Case YesNo

Case vbYes
UserForm55.Show
Unload UserForm47

Case vbNo €˜#3
'loop back to Case vbNo '#2...directly above...


End Select
End Select
End Select



Regards,
Ryan--

--
RyGuy