Message boxes

[Colin Foster]

Hi,
I want to set up a message box which if "Yes" is clicked a further message
is displayed with a single "OK" button and if "No" is clicked a different
message appears.
Any suggestions?
Regards
Colin Foster

 

[Rick Brandt]

Hi,
I want to set up a message box which if "Yes" is clicked a further message
is displayed with a single "OK" button and if "No" is clicked a different
message appears.
Any suggestions?
Regards
Colin Foster

If MsgBox("Some Message", vbYesNo) = vbYes Then
MsgBox "Another Message Box"
Else
MsgBox "Yet Another Message Box"
End If

 

[Colin Foster]

Excellent
Easy when you know how! I'd almost got there myself, but had got the If/Then
bit confused.
Many thanks for your help
Regards
Colin Foster