Message Box Result

[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!

 

[Nikos Yannacopoulos]

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