Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Bolded text on a msgbox! (Excel 2000>)

    I often see messages pop up on screen from VBA, (usually due to run time errors - <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) where text on the msgbox is bold. Can I do this for my own msgboxes when relaying a msg to the user?

    TX

    PS: I just got the idea that the alternative is to take the effort of creating a userform, but that seems like a lot of effort for a simple msgbox.
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bolded text on a msgbox! (Excel 2000>)

    The VB/VBA MsgBox function doesn't support text formatting, so if you really need this you'd need to create a userform.

    (It is possible to use Windows API functions to create a formatted MsgBox, but the example I found recommends NOT using it for serious purposes)

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Bolded text on a msgbox! (Excel 2000>)

    Tx. Standard msgboxes will have to do then!
    Regards,
    Rudi

Posting Permissions

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