| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox "expand range as list grows"
Hi:
The following populates a listbox with values from Sheet1!A1:b19. Private Sub CommandButton3_Click() UserForm1.ListBox1.RowSource = "Sheet1!A1:b10" .......... End Sub How should UserForm1.ListBox1.RowSource = "Sheet1!A1:b10" be written to automatically increase as more items are added to the list ? Thanks TK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advanced filter dialog box, "List Range" list two ranges? | Excel Worksheet Functions | |||
| "Create a drop-down list from a range of cells" | Excel Worksheet Functions | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| copy a range of cells (a row) to the bottom of a "list" | Excel Programming | |||
Threaded Mode
