View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
SteAXA SteAXA is offline
external usenet poster
 
Posts: 22
Default Answer Message Box - Other than Y/N?

MsgBox(prompt[, buttons] [, title] [, helpfile, context])

In buttons you can use VbYesNoCancel
if user select:
yes msgbox return vbYes (=6),
no msgbox return vbNo (=7),
cancel msgnox return vbCancel (=2).

Ste'