Results 1 to 6 of 6

Thread: Format MsgBox

  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Format MsgBox

    I'm a VB novice; I need to YELL certain things at my distributed spreadsheet users. Is there a way to format the fonts in a standard MsgBox to Bold, or do I have to create a Userform?
    -John ... I float in liquid gardens
    UTC -7ąDS

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Format MsgBox

    John,
    I'd create a userform. The only way I know of to have bold text in a message box is to change your display settings. It may be possible to do that with an API call then reset them after the messagebox has been displayed but that seems a little excessive to me! How about using capitals?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format MsgBox

    Rory's right. A UserForm can be customized much more than a standard messagebox. See my post "Here's a fun one"...You're busted!!

    Many helpful suggestions were given as to how to 'instruct and educate' my Excel users.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format MsgBox

    In Access 97 and earlier it was possible to at least bold part of the messagebox text, but that no longer works in Access 2000; so I, too, suggest a userform alternative.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Bethel, CT, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format MsgBox

    Charlotte,
    Are you referring to the use of the @ sign within the message text? I have found that very handy and use it quite often, even placing @@ at the end of the text to bold the entire thing. Will I lose that when I upgrade to Access 2000?

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format MsgBox

    Yep, sorry about that. The @ signs are returned as literals in Access 2000.
    Charlotte

Posting Permissions

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