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

Topic

New Reply

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?

Reply | Quote

Replies

There’s an inconclusive thread about this from about a year ago – see post 358653.

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.

Reply | Quote