| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Example of box with more than OK and cancel options?
I've looked and looked on the net for example of inputboxes or message
boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
a = MsgBox("Examples...", vbYesNoCancel)
Check help Mangesh "StargateFan" wrote in message ... I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
msgbox "OK",vbYesNocancel
-- HTH Bob Phillips "StargateFan" wrote in message ... I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
On Wed, 1 Jun 2005 13:29:26 +0100, "Bob Phillips"
wrote: msgbox "OK",vbYesNocancel Yes, I saw that, but it's not "No" I need. Sorry, I really must not have been clear in my original question, then. I need to put a box that actually has a small phrase on it. That's what I meant. Is there a way to do that? No and Cancel pretty much mean the same thing in terms of end result, so the above is no good. Thx much. :oD -- HTH Bob Phillips "StargateFan" wrote in message .. . I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
You can do that with mgbox
ans = MsgBox("my phrase", VbYesNo) Mangesh "StargateFan" wrote in message ... On Wed, 1 Jun 2005 13:29:26 +0100, "Bob Phillips" wrote: msgbox "OK",vbYesNocancel Yes, I saw that, but it's not "No" I need. Sorry, I really must not have been clear in my original question, then. I need to put a box that actually has a small phrase on it. That's what I meant. Is there a way to do that? No and Cancel pretty much mean the same thing in terms of end result, so the above is no good. Thx much. :oD -- HTH Bob Phillips "StargateFan" wrote in message .. . I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
On Tue, 7 Jun 2005 17:08:57 +0530, "Mangesh Yadav"
wrote: You can do that with mgbox ans = MsgBox("my phrase", VbYesNo) ? Huh? I still only "Yes" and "No" as the buttons. I need a third button with a phrase. Will the above do that? Somehow, I'm not sure. I think the phrase above is for the title bar only not for a button, yes? "StargateFan" wrote in message .. . On Wed, 1 Jun 2005 13:29:26 +0100, "Bob Phillips" wrote: msgbox "OK",vbYesNocancel Yes, I saw that, but it's not "No" I need. Sorry, I really must not have been clear in my original question, then. I need to put a box that actually has a small phrase on it. That's what I meant. Is there a way to do that? No and Cancel pretty much mean the same thing in terms of end result, so the above is no good. Thx much. :oD -- HTH Bob Phillips "StargateFan" wrote in message .. . I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Example of box with more than OK and cancel options?
If you want a phrase for the button, use a userform.
Mangesh "StargateFan" wrote in message ... On Tue, 7 Jun 2005 17:08:57 +0530, "Mangesh Yadav" wrote: You can do that with mgbox ans = MsgBox("my phrase", VbYesNo) ? Huh? I still only "Yes" and "No" as the buttons. I need a third button with a phrase. Will the above do that? Somehow, I'm not sure. I think the phrase above is for the title bar only not for a button, yes? "StargateFan" wrote in message .. . On Wed, 1 Jun 2005 13:29:26 +0100, "Bob Phillips" wrote: msgbox "OK",vbYesNocancel Yes, I saw that, but it's not "No" I need. Sorry, I really must not have been clear in my original question, then. I need to put a box that actually has a small phrase on it. That's what I meant. Is there a way to do that? No and Cancel pretty much mean the same thing in terms of end result, so the above is no good. Thx much. :oD -- HTH Bob Phillips "StargateFan" wrote in message .. . I've looked and looked on the net for example of inputboxes or message boxes that have more than the options of OK and cancel, i.e., to do a third thing. But have not had any luck. I guess it's because I don't know what to ask for so my search brings up a wide variety of possible responses but that don't deal with the question at hand. Can someone pls point me to what this would be called, perhaps? I just need to see some working code to figure this out. Tx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tools options view window options | Excel Discussion (Misc queries) | |||
| Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
| how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
| How to diasble the 'Tools - Options - View - Comments' options? | Excel Programming | |||
| Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
![StargateFan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
