Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Message box buttons

  1. #1
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!
    Kristy

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  4. #4
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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).
    Kristy

  5. #5
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Kind Regards,
    Ivan F Moala From the City of Sails

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •