Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform-List box help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform list box population | Excel Discussion (Misc queries) | |||
VBA userform | Excel Worksheet Functions | |||
list userform | Excel Discussion (Misc queries) | |||
Userform | Excel Worksheet Functions | |||
Userform List box to Text Box | Excel Discussion (Misc queries) |