Hi Guys

How do I add items to a list box i have created on a sheet?

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" wrote in message
...
Hi Guys

How do I add items to a list box i have created on a sheet?