Hello all!
I have 2 combo boxes, first one has a choice of 3 people. When one of them is chosen, I want the 2nd combo box to list items from that persons table/cell range. Lets say I chose 1 of a,b, or c in the first box.
Each choice has their own list to be used. A uses table choice1, B choice2 and so on. I tried using vba to just assign the rowsource after the "Change" in the first box but it doesn't work. What am I missing?
I was using:
Using choice2 and choice3 as needed. TIA
I have 2 combo boxes, first one has a choice of 3 people. When one of them is chosen, I want the 2nd combo box to list items from that persons table/cell range. Lets say I chose 1 of a,b, or c in the first box.
Each choice has their own list to be used. A uses table choice1, B choice2 and so on. I tried using vba to just assign the rowsource after the "Change" in the first box but it doesn't work. What am I missing?
I was using:
VBA Code:
combobox2.rowsource = "choice1"