Message Box Result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Yes / No message box but I don't know what the code is from the
results. I think I need to use vbMsgBoxResult within vb but I'm not sure
where it fits into the coding!

Help!
 
Pap,

Instead of just MsgBox (Prompt, Type, Title), use a variable to collect
the response, like:

vResponse = MsgBox (Prompt, Type, Title)

and then,

If vResponse = vbYes Then
'code to execute if Yesv
Else
'code to execute if No
End If

HTH,
Nikos
 
Back
Top