Message boxes

[sensi]

How do I determine which button was pressed on a vbyesNoCancel message box?

[Edneeis]

mbResponse=Msgbox("Push Yes, No, or Cancel",vbYesNoCancel,"Response Handling")
If mbResponse=vbYes then

elseif mbResponse=vbNo then

else
'must be vbCancel

end if

or use the select case method either way

[kurtsimons]

a = msgbox("what",vbyesnocancel,"title")

select case a

case vbno

case vbyes

case vbcancel

end select

[kurtsimons]

you beat me!