Drop Downs getting bigger

[tmusur]

I have a workbook with an active X combo box as a drop down in it and every
time you select a different value in the drop down the drop down will
automatically resize and get bigger. I tried closing Excel and reopen and it
does the same thing. I then tried a different template with a drop down and
it started doing the same thing. The only thing that I figured out that
fixes this is to do a reboot. Does anybody know why this happens every once
in a while so I don't have to reboot all of the time.

Thanks,

 

[Simon Murphy]

Is your worksheet zoomed to something other than 100%
Activex controls have always been flaky in Excel, especially when the
sheet is zoomed to anything except 100%

to fix just use 100%, or replace with the far more stable forms controls

Cheers
Simon
Excel development website: www.codematic.net