lisbox column width

jamielill

Active Member
Joined
Jul 27, 2009
Messages
286
I am try to use the following code to dynamically change the width of a list box in excel vba
But I cannot get line 4 going

dim c as long
c = 0
For c = 0 To 5
With UserForm1.listbox1
.Column (c)
.ColumnWidth = c + 2
End With
Next c

Any helps would be appreciated

Thanks
Jamie Lill
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,109,487
Messages
5,529,156
Members
409,851
Latest member
Ingar
Top