ComboBox autosize

**GIP** · 08-21-2010, 11:42 AM

What do I have to do / what properties do I have to change in order to prevent my ComboBox / text in ComboBox, from chaning size every time I select an entry in it?

**MarvinP** · 08-21-2010, 03:16 PM

Click on the combobox you created in the userform and look for the property of Autosize - Set that to False.
See attached file.

**GIP** · 08-22-2010, 01:22 PM

Thanks for that. I have however done that already and it has not seemed to help. I used the Forms Toolbar and originally, the combobox was getting smaller while the text stayed the same size. Currently, the combobox is staying the same size, and the text seems to be growing exponentially each time I select and entry in it.

**MarvinP** · 08-22-2010, 01:42 PM

Can you post your userform in a sample spreadsheet? It sounds like there is a zoom in or font resize going on in the code somewhere. Was I specific enough when telling you to set Autosize? You nee to be in your Userform design, click on the combobox and then look at the Properties window for your combobox. If you click on the Categorized tab, Autosize will be the first entry under the Behavior grouping. Change it from False to True. I'd also try changing other properties like "MatchEntry" to see if that is making the font or box grow. For help with any of the properties, simply click on it and press F1.
I hope that helps.