How to trigger an event based on the response of a message box? 1

[gabrielbatistuta]

I have created a combo box and when the user clicks for ie "People Development" a form will open.

I have done that. But I want to display a message box with Yes and No and when the user clicks on Yes the form will open automatically. How do I store the value of the response in VBA.

A sample code is greatly appreciated.

 

[PHV]

Ask the VBA help for MsgBox

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

If MsgBox("Your message here.", "Title", vbYesNo) = vbYes Then
   Code to open form here.
End If

Randy