I'm at my wits' end with this - I've searched multiple places on the web and gotten exactly 0 working suggestions, though it seems other people have run into this problem as well. I'm using Excel 2007 SP2 on Windows XP.
The problem is that when I open my spreadsheet on computers with different screen resolutions, either the combobox/listbox resizes itself, or the font size changes to nearly unreadable size.
I've tried setting IntegralHeight to both true and false, and the Placement value to 2 or 3, and nothing seems to work, the moment I change screen resolution the listbox or combobox is messed up.
At this point I have no ideas left aside from saving all the properties for each control and forcing them back to their original values every time the screen resolution changes (assuming I can even detect that).
The problem is that when I open my spreadsheet on computers with different screen resolutions, either the combobox/listbox resizes itself, or the font size changes to nearly unreadable size.
I've tried setting IntegralHeight to both true and false, and the Placement value to 2 or 3, and nothing seems to work, the moment I change screen resolution the listbox or combobox is messed up.
At this point I have no ideas left aside from saving all the properties for each control and forcing them back to their original values every time the screen resolution changes (assuming I can even detect that).