Thank you, that was what I was after.

"Chip Pearson" wrote:

Try

Dim Res As Long
Res = MsgBox("Are you sure?", vbYesNo, "Title")
If Res = vbYes Then
' user clicked yes
Else
' user clicked no
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"sbmr" wrote in message
...
Years ago I managed to write a macro in excel that brought up
a window with
a yes or no option. I have forgotton how I did that and do not
have the said
file anymore.
What is that window called so I can look it up in the help?