msgbox in macro

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

I am writing a msgbox in a macro which is an action. How can I make yes or
no button in this action? Thanks.
 
Hi,
you don't really need a macro for this.
You could try the following code on whatever form event you want to use:

Select Case MsgBox("Your Message Text", vbYesNo Or vbExclamation Or
vbDefaultButton1, Application.Name)
Case vbYes
'yes was clicked so do something
Case vbNo
'no was clicked so do something else
End Select

Or if you want to stick to an if then statement:

If Msgbox("Your Message Text",vbYesNo,"Your Title") = vbYes Then
'yes was clicked so do something
End If

HTH
Good luck
 
Help file for MsgBox (go to your macro, click in the "field" where MsgBox
action is shown, and press F1) will give you information about this.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro question regarding msgbox's 4
How to Create a Macro to Import External Data 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
MsgBox Yes/No/Cancel change to Save/Delete/Amend 1
only part working as macro - think need code! 1
vba macro that allows insertion of symbols at cursor 0
msg box - remove check box or keep check box in form 1
Creating a function? 13

Back
Top