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

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

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

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