msgbox coding

J

Junior

how can i modify the following to have the 'No' button in the messagebox as
the default button?

intAns = MsgBox("Are you finished?" _
, vbYesNo + vbQuestion, " Reminder")
If intAns = vbYes Then
 
J

Jeff Conrad

Try:

intAns = MsgBox("Are you finished?" _
, vbYesNo + vbQuestion + vbDefaultButton2, " Reminder")
If intAns = vbYes Then
 
J

Junior

Jeff thanks
Jeff Conrad said:
Try:

intAns = MsgBox("Are you finished?" _
, vbYesNo + vbQuestion + vbDefaultButton2, " Reminder")
If intAns = vbYes Then
Click to expand...
 
Top