S
sal21
In effect when the userform initialize i would want to show into firs
line of listbox1 the 6 value from the sheet named CODICI range S1:X
with a little tipical border...
Have maked this but the value are out respect the first line...
Help me!
With Me.ListBox1
.Clear
.ColumnCount = 6
.ColumnHeads = True
.AddItem
For I = 0 To 5
.List(0, 0 + I) = Sheets("CODICI").Cells(1, 19 + I).Value
Next I
End With
see the image attached..
+-------------------------------------------------------------------
|Filename: listbox.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4287
+-------------------------------------------------------------------
line of listbox1 the 6 value from the sheet named CODICI range S1:X
with a little tipical border...
Have maked this but the value are out respect the first line...
Help me!
With Me.ListBox1
.Clear
.ColumnCount = 6
.ColumnHeads = True
.AddItem
For I = 0 To 5
.List(0, 0 + I) = Sheets("CODICI").Cells(1, 19 + I).Value
Next I
End With
see the image attached..
+-------------------------------------------------------------------
|Filename: listbox.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4287
+-------------------------------------------------------------------