Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box Setup from Varying 1d 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box Setup from Varying 1d Array
Private Sub Userform_Initialize()
Dim rng as Range with worksheets("Data") set rng = .Range(.Range("B2"),.Range("B2").End(xldown)) End with Listbox1.RowSource = rng.Address(external:=True) listbox1.Value = Application.UserName End Sub -- Regards, Tom Ogilvy "Andrew Heath" (delete) wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create List sourced from Multiple sheets of varying lengths | New Users to Excel | |||
Array for varying 2 out of many input variables for complicated fx | Excel Discussion (Misc queries) | |||
using VB to read in a column of values of varying length into an array | Excel Worksheet Functions | |||
How: List in col D whichever number greater; B4 or varying # in Co | Excel Discussion (Misc queries) | |||
Trying to generate a quantity from a list of doors with varying at | Excel Discussion (Misc queries) |