VbYesNo - Default NO

[lapacotee]

Is it possible to set the focus of a vbYesNo MsgBox to NO? If so, how?

Thank you,
Tee
Lapaco

 

[Scott Huish]

Try something like this:

Sub test()
Dim x
x = MsgBox("Test", vbYesNo + vbDefaultButton2)
End Sub

 

[TheNoocH]

try something like this...the 260 says it's a vbYesNo and No is default...see vba help file on "MsgBox Function"

Sub tstmsgb()
test = MsgBox("test", 260)
End Sub

EDIT****just found out the easier way...Hotpepper beat me to it...i knew i had it in one of my files couldn't find it initially....I would personally use Hotpeppers approach

Note if you want to include the type of msgbox too
msgbox("test", vbYesNo+vbExclamation+vbDefaultButton2)