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

--
Message posted from http://www.ExcelForum.com

Hi tanktata

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




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"tanktata " wrote in message ...
I know this is probably really easy to do, but how do you populate a
list or combo box with data from an existing range, without having to
add each individual item?

Thanks.


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

thanks for your help folk

--
Message posted from http://www.ExcelForum.com