How would I populate a list box with values from rows in anothe worksheet
J Jan Karel Pieterse May 11, 2004 #2 Hi Dovrox, How would I populate a list box with values from rows in another worksheet. Click to expand... Give the range with the values a name (insert, name, define) and use that name as the listsource property. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
Hi Dovrox, How would I populate a list box with values from rows in another worksheet. Click to expand... Give the range with the values a name (insert, name, define) and use that name as the listsource property. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
J Jason Morin May 11, 2004 #3 You'll have to use a named range. Select the range and press Ctrl+F3 and give it a name like "mylist" (no quotes). Then under Properties of the Listbox use mylist for the ListFillRange. HTH Jason Atlanta, GA
You'll have to use a named range. Select the range and press Ctrl+F3 and give it a name like "mylist" (no quotes). Then under Properties of the Listbox use mylist for the ListFillRange. HTH Jason Atlanta, GA
