ComboBox Autosize Font

**yawnzzzz** · 04-05-2011, 01:56 PM

Is there a way to automatically change the font size of a ComboBox, so that the selection fits? I see that I can make the ComboBox size change, but I'd prefer keeping that the same size.

**snb** · 04-05-2011, 02:35 PM

No, it's not one of it's properties.
You need to add some VBA-code to realise this.

**yawnzzzz** · 04-05-2011, 03:08 PM

I'm dealing with hundreds of fields, so I wouldn't want it to run to determine the font size during the initialize step. Is it possible to write VBA to change the font size setting permanently? So that whenever I change the lists of my dropdowns, I can run the code to update the font sizes prior to sending it out to anyone.

**snb** · 04-05-2011, 03:58 PM

Now you have to be more specific:
are you talking about:

- comboboxes in a sheet
- comboboxes in a userform
- comboboxes in a commandbar

Are you really using 'hundreds' of comboboxes ?
If so, I'd advise to scrutinize your project again to see whether that quantity can be reduced before writing code.
'structuring precedes coding'