ListBox
Hi Guys
How do I add items to a list box i have created on a sheet? |
ListBox
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? |
All times are GMT +1. The time now is 10:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com