Ed,
Two ways, based upon a control listbox
1. Listbox1.Additem "abc" etc
2. Set the ListFillRange property to a worksheet range (A1:A10 for instance)
that contains the items
If it's a Forms listbopx. set the Input range in the Format Control option.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
