ListBox size change on different PC's

  • Thread starter Thread starter PeterN
  • Start date Start date
P

PeterN

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ListBox Size and Screen Resolution 2
Removing Scroll Bars from a Listbox on a Form 3
Listbox from "Forms" toolbar 2
Listbox Change events triggering when i "Save As" 4
Using VBA to change Excel layouts 2
listbox assistance 2
Label controls change apparent font size when moved up/down 3
VBA Chart Size Accuracy 1

Back
Top