ComboBox changes sizes as I zoom in and out....

[albertc30]

Hi all.

I have this comboBox on my invoice sheet.

All works out great but I have got a macro that runs and when it opens the document it zooms the sheet to fit the screen width.

The problem is that the comboBox that was done with the help of ALT to fit the size of the cell, is now outside the cell, being bigger than the cell.

Is there a workaround this annoying thing?

Regards,
Albert

 

[sijpie]

http://www.mrexcel.com/forum/excel-...-code-adjusting-worksheet-name-box-width.html

this might give you something to play with