Tim,

See VBA Help on Msgbox. All you need is there & then some...

Example:

Mgsbox "Today is Friday ?", VbYesNo + vbDefaultButton2
will default to No

Mgsbox "Today is Friday ?", VbYesNo + vbDefaultButton1
Will Default to Yes

Jeff


"tim64" wrote:


how do you make a certain MsgBox always say yes or no.
example when it asks to save it always says yes automaticly.


--
tim64
------------------------------------------------------------------------
tim64's Profile: http://www.excelforum.com/member.php...o&userid=23295
View this thread: http://www.excelforum.com/showthread...hreadid=376894