Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox Populate
If the combo is from the 'Forms' tool bar, then right
click on the combo, select 'Format Control' and in the 'Input Range' on the 'Control' tab put =MyList I Found this In the board however I cant find the Form Control or Input Range I have A list box on a User Form and I want to populate it from a range in the sheet. Thanks for any help Rod Taylor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox Populate
I have a webpage devoted to listboxes.
www.rubbershoe.com/listbox.htm "Rod Taylor" wrote in message ... If the combo is from the 'Forms' tool bar, then right click on the combo, select 'Format Control' and in the 'Input Range' on the 'Control' tab put =MyList I Found this In the board however I cant find the Form Control or Input Range I have A list box on a User Form and I want to populate it from a range in the sheet. Thanks for any help Rod Taylor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox Populate
If on a userform, it is from the control toolbox toolbar.
In the VBE, click on the listbox, then look in the properties Window (F4 if it isn't visible). Find the RowSource property and put in something like Sheet1!A1:A10 Regards, Tom Ogilvy "Rod Taylor" wrote in message ... If the combo is from the 'Forms' tool bar, then right click on the combo, select 'Format Control' and in the 'Input Range' on the 'Control' tab put =MyList I Found this In the board however I cant find the Form Control or Input Range I have A list box on a User Form and I want to populate it from a range in the sheet. Thanks for any help Rod Taylor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox Populate
Thanks For the help That was quick
"Rod Taylor" wrote in message ... If the combo is from the 'Forms' tool bar, then right click on the combo, select 'Format Control' and in the 'Input Range' on the 'Control' tab put =MyList I Found this In the board however I cant find the Form Control or Input Range I have A list box on a User Form and I want to populate it from a range in the sheet. Thanks for any help Rod Taylor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populate ldropdown listbox from a dbf. file | Excel Discussion (Misc queries) | |||
Array to Populate ListBox Problem | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Listbox B if LIstbox A equals | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |