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
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
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".
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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