Link to home
Start Free TrialLog in
Avatar of Pachecda
Pachecda

asked on

Excel Active X Control Combo Box Sizes down every time I clicked.

Hi guys,

I have setup two combo box to test out why the combo boxes (form or active x) changed in size right after a user clicks on the list of values. At first I thought it was the form control, then I changed it to active x control and it does the same. Basically, my active x or form control box just shows the custom views setup in excel to show actuals (if user selects it), or budgets, etc.

I have setup a couple of macros to execute upon the change event that shows the custom views. My vba needs to be cleaned up to make it more efficient. text-active-x-control.xlsm
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

I didn't try your project but i'm surprised that the form control combo box changes size. The problem with that control is the small size of the font which can't be changed. ActiveX comboboxes changing size is a known problem when used on a sheet since they are not actually designed for that use. You can however use the floating combo box method described in my article and it won't change size.
Option B is to simply add code to the end of your macro that sets the size of your box when it finishes.  That was my workaround for this when I encountered this same issue and realized there was not a "fix", only a "workaround".
Avatar of Pachecda
Pachecda

ASKER

I can live with the workaround as long as it works. In addition, my vba is a little bit ugly and I was hoping some one can help me clean it. It will be great if you modify the vba and upload the sheet so I can test it.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Martin, like you said, your solution is completely different, but it works as a work around.
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014