Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Message Boxes (Excel 2000)

    It is possible to alter the font size and enbolden text in an input message box? Thanks.

    Farmer

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

    Re: Message Boxes (Excel 2000)

    No, that is not possible. If you want a customized message box or input box, you must create a UserForm (Insert | UserForm in the Visual Basic Editor), put the appropriate controls on it and use code to display it.

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Message Boxes (Excel 2000)

    No, the user's Windows Display Properties settings will determine the font type, size, etc that is displayed in a generic VB/VBA MsgBox or InputBox. If for some reason the user desires to have MsgBox messages displayed in Comic Sans MS 12 point, for example, they can set these attributes as illustrated (Win XP "Advanced Appearance" dialog). If you want to customize the font, etc the most viable option is to create your own customized dialog box using a modal UserForm (set UserForm's ShowModal property to True (the default)).

    HTH

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Message Boxes (Excel 2000)

    Thanks Mark D and HansV. I guess it's the user form.

Posting Permissions

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