View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default msgbox button constants

Change and to or.

Alok Joshi

"Justin" wrote:

hey there,
i'd appreciate some help.

I am trying to modify a message box prompt. I want to combine the vbYesNo
buttons and the vbexclamation icon. My code is as follows:
MsgBox("question to user.",vbYesNo and vbExclamation, "Title")
but when i use this, no exclamation icon shows and there are no yes/no
buttons.
Separately, they work fine, but added together i cannot get either one to
work. It just shows an "ok" button and no icon.

is there a way i can obtain both formats?
Thanks,
Justin