Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox button constants
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox button constants
Alok,
Thanks that did it, perfectly. "Alok" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customize a button on a MsgBox? | Excel Programming | |||
constants | Excel Discussion (Misc queries) | |||
constants | Excel Programming | |||
Msgbox button labels | Excel Programming | |||
Cancel button to bypass MsgBox | Excel Programming |