Message box with multiple buttons

  • Thread starter Thread starter LB79
  • Start date Start date
L

LB79

Im trying to create a message box that has the message "Do you want t
print?" with buttons "Yes" and "No". When yes is selected the prin
macro is activated. When no is selceted the macro stops and goes bac
to the work sheet.
Can anyone help me?

Thank
 
Code
-------------------

If MsgBox("DO YOU WANT TO PRINT?", vbYesNo, "PRINT") = vbYes Then

'Your code for print macro

Else

End


End If
 

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

Back
Top