Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Message box is dull (Excel XP)

    Can the presentation of the Message Box be altered in VBA? I want a message box that is a little more "lively" to catch the eye of users of this edit macro I'm developing. Would there be an alternative structure I should consider? How about a little color? How about some flashy text in yellow or something? I'd like to be sure the users see the message. Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Message box is dull (Excel XP)

    I don't think it's possible to alter the format of a message box in the way you'd like - it's a system function rather than an Excel one anyway. But you could easily use a UserForm to emulate a message box, with any kind of "extras" you'd like.

    Alan

Posting Permissions

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