List Box - column widths

  • Thread starter Thread starter Robert Pollock
  • Start date Start date
R

Robert Pollock

Thanks for helping.

I have a list box showing three columns of data from
another sheet. The problem is that the widths of the
columns in the list box are really far out, and I need to
adjust them somehow.

The columns are B, E, and AA (B-D and E-Z are merged)

Here is the Listrange;

MAIN!$B$16:$AA$39

The first column especially is really wide, and results in
a massive scroll along to see the others, and strangely
the third column is thinner !

Bemused
Robert
 
You can change the column widths by going into the
properties sheet as I described in my answer to your first
post, then set the ColumnWidths property to 20,20,20 (it
will show up as 20 pt, 20 pt, 20 pt. There are 72 points
per inch, and this is the default for each column. Adjust
these numbers to fit your data. 20 pt will fit a two
digit number nicely, 30 pt for a 3 digit number, more or
less.
 
Back
Top