Something like

ans = MsgBox("Press a button", vbYesNo)
If ans = vbYes Then

You can use button values of

vbOKOnly, vbOKCancel, vbABortRetryIgnore, vbYesNoCancel, VbYesNo,
vbRetryCancel, vbCritical, vbQuestion, vbExclamation, vbInformation

and you can combine like this

vbYesNo + vbExclamation

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"dcstech" wrote in message
...
How do you get the return status from a message box............i.e. What
button was pushed?