Active X control error

[tybaltlives]

I've run into this several times before in a variety of situations. Hoping to find a real solution this time.

I have both a combobox and a command button imbedded in my spreadsheet that run macros when clicked.

The problem is, every time I click on a control it makes the increases the size of the control and also decreases the size of the caption text. After about 5 clicks, the control is unreadable and also covering up the spreadsheet.

This is really annoying because sometimes it happens, sometimes it doesen't. In the past, I have had to use code to reset the pertinent parameters of the control after all macros have been run. But this is cumbersome.

Has anyone ever run into this issue AND FOUND A WAY TO FIX IT?

Thanks

 

[vaskov17]

can you post the macros associated with the controls?

 

[RoryA]

Code is the only way. Avoiding zoom levels other than 100% helps, but is not foolproof. ActiveX controls are simply not completely stable on worksheets.

 

[Andrew Poulsom]

I've never seen a definitive fix, other than to use controls from the Forms Toolbar instead. I believe it has something to do with using a screen resolution other than the default.

 

[tybaltlives]

OK guys. Thanks. I suppose I could set up a form on the worksheet. If that avoids this issue.

Appreciate the feedback.

-R