Message box buttons

[Von Pookie]

This is probably a rather stupid question:

Can you have "custom" message box buttons?
I currently have a message box that has choices of Yes or No. I would like them to say Open or Close.

Or, if not at all possible, just let me know...

Thanks!

 

[MT_Shanachie]

On 2002-05-02 14:07, Von Pookie wrote:
This is probably a rather stupid question:

Can you have "custom" message box buttons?
I currently have a message box that has choices of Yes or No. I would like them to say Open or Close.

Or, if not at all possible, just let me know...

Thanks!

Not completely sure on this, but I think you'll need to create a Userform instead of using a message box. The message box button choices are listed in the help for MsgBox

 

[Al Chara]

The following are your options for buttons in the msgbox

OK
OK/Cancel
Abort/Retry/Ignore
Yes/No
Yes/No/Cancel
Retry/Cancel

You can also have other options like, special icons...critical, question, exclamation, information.

 

[Von Pookie]

I don't have vba help installed on excel at work, which is where I'm working on this.

Would a userform be worth it? I only use the message box at the very beginning and that's it (choose 1, I'm done with it and don't ever see it again).

 

[Ivan F Moala]

On 2002-05-02 14:07, Von Pookie wrote:
This is probably a rather stupid question:

Can you have "custom" message box buttons?
I currently have a message box that has choices of Yes or No. I would like them to say Open or Close.

Or, if not at all possible, just let me know...

Thanks!

If you MUST have the msgbox say OPEN or CLOSE
the you would have to use a Userform with
these buttons on.

 

[Jack in the UK]

hardly a silly question but no this can not be done as i know but////

load a blank userform and add active x command thes can be what ever you like and custom to whatever you like .. or

add a drawing object and custom each add a script to so wil be just as yes no what ever the code not so hard for these simple commands..

On 2002-05-02 14:07, Von Pookie wrote:
This is probably a rather stupid question:

Can you have "custom" message box buttons?
I currently have a message box that has choices of Yes or No. I would like them to say Open or Close.

Or, if not at all possible, just let me know...

Thanks!