Hi,

I have a 3 column list box. Columns 1 and 2 are very small, 3 or 5
characters only. The 3 column is much longer. Is there a way I can adjust
the first two columns so I don't have all this dead space?

Thanks,

You can set the column widths in the properties window in the VBE editor in
design mode.

From the VBA help file:

Unless specified otherwise, column widths are measured in points. To specify
another unit of measure, include the units as part of the values. The
following examples specify column widths in several units of measure and
describe how the various settings would fit in a three-column list box that
is 4 inches wide.

Setting
90;72;90
Effect
The first column is 90 points (1.25 inch); the second column is 72 points (1
inch); the third column is 90 points.


"Karen53" wrote:

Hi,

I have a 3 column list box. Columns 1 and 2 are very small, 3 or 5
characters only. The 3 column is much longer. Is there a way I can adjust
the first two columns so I don't have all this dead space?

Thanks,

Thank you. I tried that but I don't think I had the correct formatting.
I'll try again.

"JLGWhiz" wrote:

You can set the column widths in the properties window in the VBE editor in
design mode.

From the VBA help file:

Unless specified otherwise, column widths are measured in points. To specify
another unit of measure, include the units as part of the values. The
following examples specify column widths in several units of measure and
describe how the various settings would fit in a three-column list box that
is 4 inches wide.

Setting
90;72;90
Effect
The first column is 90 points (1.25 inch); the second column is 72 points (1
inch); the third column is 90 points.


"Karen53" wrote:

Hi,

I have a 3 column list box. Columns 1 and 2 are very small, 3 or 5
characters only. The 3 column is much longer. Is there a way I can adjust
the first two columns so I don't have all this dead space?

Thanks,