Listbox size changes when opening Excel

[Sean]

I use an imbedded ActiveX listbox in an Excel document.
If the document "Zoom Magnification" is set to something
less than 100%, then whenever I open the Excel document,
the size of the listbox gets smaller.

For example, if the "Zoom Magnification" for the Excel
document is set to 75%, and the list box has a width of 1
inch and a height of 2 inches, then the next time I open
the document, the listbox automatically resizes to a
width of 0.75 inches and a height of 1.5 inches, and I
have to go into "Design" mode to change the listbox size
back to what I want.

Any help to solve this would be greatly appreciated!

Sean

 

[Jamie Collins]

I use an imbedded ActiveX listbox in an Excel document.
If the document "Zoom Magnification" is set to something
less than 100%, then whenever I open the Excel document,
the size of the listbox gets smaller.

For example, if the "Zoom Magnification" for the Excel
document is set to 75%, and the list box has a width of 1
inch and a height of 2 inches, then the next time I open
the document, the listbox automatically resizes to a
width of 0.75 inches and a height of 1.5 inches, and I
have to go into "Design" mode to change the listbox size
back to what I want.

I've seen this before with an Activex combobox when the zoom setting
is altered after the workbook has been opened. I assume this is a bug:
the ActiveX controls seem to be buggy when used on a worksheet.

My workaround was to re-initialize the size, fonts, etc in a suitable
event e.g. the control's Click event (or in your case, Workbook_Open,
perhaps).

Jamie.

--