Hi,
I'm trying to populate a listbox based on the selection i made in the previous listbox,
e.g. I'm selecting country in listbox1,
state in listbox 2
i want hotel names in listbox 3 to populate according to the states i've selected in listbox 2.
i've used this code to do it so far-using dynamic named ranges, but im wondering if there is another way to do it?
the code currently only works when the item in the listbox is clicked on, wondering if i can change the code such that if an item is ADDED to a particular listbox, the list for this item will automatically populate in the next listbox
thanks !!
Bookmarks