Width property

  • Thread starter Thread starter jim c.
  • Start date Start date
J

jim c.

does anyone know of a way to convert the coulmn width
value returned on a worksheet into points that can be used
for column width for a listbox on a userform?

listbox rowsource is a named range.

Currently I use just the value returned to autosize
columns in my listbox, but of course is not accurate and
the differences are cumulative. I have 14 columns in
listbox and would like to regain wasted space between
columns to maybe eliminate having to horizontal scroll to
last column.

I appreciate your input. This is just a curiosity, not a
problem.
 
Back
Top