| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
List Box refer to an array
Hi
I need to create a listbox1 within a userform to select one name from a list of names. The list of names varies in length from 3 to 60 people. The list of names starts at B2 and goes down (and varies in number) Can I get it to default to the 'users' name (from ToolsOptions...General)? Do I have to set up a dynamic 1d array when I call up the userform? Kind regards -- Andrew 'The Ox' Heath Brisbane, QLD Australia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
