| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a list of items onto a list box on a form
Hi there,
I'm stuck and can't seem to figure out how to get a list that I have of 5 names onto a list box on a form I've created. Anyone done this before. Any help greatly appreciated Thanks Sandra |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get a list of items onto a list box on a form
Sandra,
Something like this in the code module for the form. It runs every time the form is loaded (not when it's shown). '------------------------------------------- Private Sub UserForm_Initialize() Dim varArray As Variant varArray = Array("Larry", "Moe", "Curly", "Ashley", "Judd") UserForm1.ListBox1.List = varArray End Sub '------------------------------------------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Grd" wrote in message Hi there, I'm stuck and can't seem to figure out how to get a list that I have of 5 names onto a list box on a form I've created. Anyone done this before. Any help greatly appreciated Thanks Sandra |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get a list of items onto a list box on a form
Thanks
this works well "Jim Cone" wrote: Sandra, Something like this in the code module for the form. It runs every time the form is loaded (not when it's shown). '------------------------------------------- Private Sub UserForm_Initialize() Dim varArray As Variant varArray = Array("Larry", "Moe", "Curly", "Ashley", "Judd") UserForm1.ListBox1.List = varArray End Sub '------------------------------------------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Grd" wrote in message Hi there, I'm stuck and can't seem to figure out how to get a list that I have of 5 names onto a list box on a form I've created. Anyone done this before. Any help greatly appreciated Thanks Sandra |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation list - list doesn't show items from top | Excel Discussion (Misc queries) | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
| How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
| 2nd Form deselects list box items on main form | Excel Programming | |||
Linear Mode
