Userform-List box help
Kimberly,
You can use the initialize event of the form
Private Sub UserForm_Initialize()
Dim x As Long
For x = 3 To 13
ListBox1.AddItem (Cells(9, x))
Next
End Sub
You can use a specific sheet with Sheets("Sheet1").Cells(9,x)
--
sb
"KimberlyC" wrote in message
...
Hi
I have a row of data ( row 9 --- column c through m) on a worksheet that
I
would like to display in a listbox (in a userform). I know how to display
a
column of data in a listbox...but not a row.
Is it possible to display a row of data in a listbox?
Thanks in advance for your help!
Kimberly
|