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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
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.
RayData AnalystCommented:
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".
PachecdaAuthor Commented:
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.

JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Martin LissOlder than dirtCommented:
I attached a workbook that takes a different approach. All the code I added including code in Workbook_Open and Module1 is marked with 'New

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PachecdaAuthor Commented:
Thanks Martin, like you said, your solution is completely different, but it works as a work around.
Martin LissOlder than dirtCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.