B Bob Phillips Feb 6, 2004 #2 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)
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)
