ListBox Populate

[Rod Taylor]

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

 

[Tim Zych]

I have a webpage devoted to listboxes.

www.rubbershoe.com/listbox.htm

 

[Tom Ogilvy]

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]

Thanks For the help That was quick

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