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
+-------------------------------------------------------------------

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=50715