I am afraid that you cannot have Maybe as this technique uses built-in
buttons, but you could use Cancel

Dim ans As Long
ans = MsgBox("Select Yes or No", vbYesNoCancel)
If ans = vbYes Then
Range("N53").Value = "Yes"
ElseIf ans = vbNo Then
Range("N53").Value = "No"
Else
Range("N53").Value = "Maybe"
End If



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chalky" wrote in
message ...

The msgbox idea worked perfectly thanks! One think i wanted to add
though was further options, ie yes, no, maybe (amongst others).

Any ideas on how this would work? I can't say i am familiar with the
combobox.

Thanks for your help so far

chris


--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=501107