MsgBox Help

How do I make my MsgBox return a particular result? I have a vbYesNo msgbox, where i want if "Yes" is clicked then a form will open else if "No" is clicked, the message box closes and no changes are made.

I'm very new to VBA so please excuse my lack of knowledge. Thankingnyou in advance.

Type MsgBox in the code window and press f1.

Basically it this :

Msgbox "Message",<buttons> + <icons>,"Title" <<< Displays the message only
Msgbox ("Message",<buttons> + <icons>,"Title") <<< Is a function thus returns the button pressed

So your code would be something like:

Code:

---

    Dim lngRes as long

    lngRes = -1
    lngRes = Msgbox("The test message",vbyesno+vbexclamation,"Title here")

    if lngRes = vbyes then
'---- do yes stuff
    else
'---- do no stuff
    end if

---

Help file has the variables / values

VB Code:

if Msgbox("The test message",vbyesno+vbexclamation,"Title here") = vbYes then
     'do yes stuff
else
     'do no stuff
endif

is quicker ;-)