ListBox Populate

  • Thread starter Thread starter Rod Taylor
  • Start date Start date
R

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
Click to expand...



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
 
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
 
Thanks For the help That was quick
Rod Taylor said:
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
Click to expand...
 
Back
Top