MsgBox with Yes/No

C

Chris Watts

"Answer = MsgBox("Do you want to continue ?", vbYesNo)" displays with the
YES button as the default. Is it possible to have the NO button as the
default?

TIA
Chris
 
A

Andy Pope

Hi,

Try,

Answer = MsgBox("Do you want to continue ?", _
vbYesNo or vbDefaultButton2)

Cheers
Andy
 

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

Excel Is it possible to ask a question within a question? 0
Prefilled Outlook Yes Voting Button response 0
Copying Row Code Doesn't Copy Conditional Formating 10
Get Name of Sheet to use in Macro 11
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Close msgbox after making selection 13
Can I customize the Yes/No buttons on a MsgBox? 7
Yes / No default to No 3

Top