Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MsgBox Command (97 SR2 VBA)

    Greetings,

    I would like to tweak the msbox command to allow me to specify what the buttons say. Is this possible? The result would be two buttons, one that says 'Development' and one that says 'Production'.

    I'd like to do this without creating another form, if possible...

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MsgBox Command (97 SR2 VBA)

    No, you can not control what displays in the buttons to be anything you want. You would have to create a userform with your own textbox and buttons.
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MsgBox Command (97 SR2 VBA)

    You don't want to do it! It is easier to design your own userform. If you insist, here are the API calls to do it. Beware, it's only been tested with VB, not VBA. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MsgBox Command (97 SR2 VBA)

    Works fine in XL2K. Nice to know this, may come in handy someday.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MsgBox Command (97 SR2 VBA)

    Wow! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    You're right, I don't want to do it... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    But, great for future reference, thanks Sammyb! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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