Change width of columns form vba

[dsellos]

Hey everybody.

I have a ListBox with seven columns.
I want each column has a specific width.

Can anyone help me?

Thanks!

 

[SkipVought]

Hi,

Turn on your macro recorder and start setting column widths.

Post back with your recorded code if you need help customizing.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dsellos]

SkipVought hey, thanks for the reply.

I want to change the column width of a ListBox, not the column of the worksheet.

Greetings

 

[SkipVought]

Listbox has a ColumnWidths property. Did you check thru the properties?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dsellos]

Thank you very much!

I never thought I'd look at the help of VBA.

thanks

 

[SkipVought]

There is actually an example in VB Help for ColumnWidths.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}