ListBox size change on different PC's
 

I'm writing VBA code for an Excel Spreadsheet (using mainly Office 97
Pro / Win95).
When ported to different Pc's, my ActiveX ListBoxes often change size.
When ported back to the original pc the size change persists or is
different again.
Not only is this annoying (spoiling the layout) but it can cause
scroll bars to appear in the list box which are unwanted and obscure
the text.
How do I stop this happening?

ListBox size change on different PC's
 

Hi Peter,

we found this happening when we were developing Name Manager.
Most of the time the problem was caused by flipping between systems with
large fonts/small fonts.
We got more stable results if we developed and shipped using small fonts.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"PeterN" wrote in message
om...
I'm writing VBA code for an Excel Spreadsheet (using mainly Office 97
Pro / Win95).
When ported to different Pc's, my ActiveX ListBoxes often change size.
When ported back to the original pc the size change persists or is
different again.
Not only is this annoying (spoiling the layout) but it can cause
scroll bars to appear in the list box which are unwanted and obscure
the text.
How do I stop this happening?