ActiveX controls shrinking (listboxes and command buttons)

[Russell Hauf]

I have an ActiveX ListBox on a worksheet that I populate at the user's request or upon start up. But I'm experiencing a strange problem: the list box changes in size (gets thinner and a bit shorter, which also affects the font inside the list box). I've also seen this before with command buttons (on a sheet that had many command buttons).

Anybody had this problem, and if so, is there a fix? I think I'm going to just change to using a form, but I'd like to know if there is a fix for future reference.

Thank you,

Russell

 

[Corticus]

Well at least I learned some new code! thanks everybody for their help...

Corticus

 

[Corticus]

As random as this is:
I centered the page horizontally, which fortunately needed to be done anyways, and bam, all my controls and check boxes line up, look right, and print like there supposed to. Only 4 hours on a check box, not bad!