Using a specific range to populate a list/combo box

[tanktata]

I know this is probably really easy to do, but how do you populate
list or combo box with data from an existing range, without having t
add each individual item?

Thanks

 

[Ron de Bruin]

Hi tanktata

There is a list property
ListBox1.List = Sheets("Sheet1").Range("D120").Value

 

[btadams]

If you're using controls from the Control Toolbox, select the control o
the spreadsheet then click on the Properties button on the Contro
Toolbox. Then change the ListFillRange property to WorksheetName!Rang
(such as Sheet2!A1:A100). You can leave off the ws name if the range o
cells is on the same worksheet as the contro

 

[tanktata]

thanks for your help folk