ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Example of box with more than OK and cancel options? (https://www.excelbanter.com/excel-programming/330611-example-box-more-than-ok-cancel-options.html)

StargateFan[_3_]

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.


Bob Phillips[_7_]

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.




Mangesh Yadav[_3_]

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.




StargateFan[_3_]

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.




Mangesh Yadav[_4_]

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.






StargateFan[_3_]

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.






Mangesh Yadav[_4_]

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.









All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com