ActiveX combobox in spreadsheet re-sizes each time the macro runs

[jfoerch]

Hi all,
I have a combobox embedded in a spreadsheet that runs a macro each time the value is changed. Each time I change it, after the macro is run, the size of the combobox drop arrow and the text inside it is changed, it literally gets smaller as shown on my screen. When I go into the properties of the combobox, the font size is unchanged. Can anyone help me figure out what is wrong? I'm attaching the file so you can see it.

Thanks.

[Kyle123]

Use Forms controls on your worksheet rather than Active X, they are much more stable

[jfoerch]

Thanks for the advice. I played with that but was unable to figure out how to run the macro based on the value that was selected from the form control. With ActiveX, I knew it was Combobox1.value. Not sure how to get that value from a form control combobox. Any tips on how to do that?

[jfoerch]

And, can I run a macro when the combobox value is changed like I can with the ActiveX combobox?