Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    St Louis, Missouri, USA
    Thanked 1 Time in 1 Post

    Changing default font in VBE (VBA/Excel/2003)

    When I make a UserForm in Excel, I want to universally change the font size. Everything is always defaulting to 8 point and I would like to use 11. I would also like to change the font from Tahoma to Trebuchet.

    I called myself searching through the registry for an entry but could not randomly find anything. Am I going to have to continue doing this manually each time? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Changing default font in VBE (VBA/Excel/2003)

    There's an inconclusive thread about this from about a year ago - see <post#=358653>post 358653</post#>.

    When you create a new userform, you can set the font for the form as a whole. All controls you create on the userform will use those font settings. But we weren't able to find a way to set the default for all new userforms.

Posting Permissions

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