What are we talking about, a userform, control toolbox, or worksheet forms?

Put the data in a worksheet range and link with
- userform - Rowsource property
- control toolbox - ListFillRange
- worksheet form - Input Range on Control Tab of Form, properties.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Arthur " wrote in message
...
I'm trying to create a drop-down list in Excel, but I can't seem to fill
out more than one row of information in either a Combo Box or List Box.
Could someone tell me how to create an actual - list - for both of
these control boxes?

thanks!!


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