S
swu012
I have several columns in a spreadsheet, each has a lis of values.
Column B's values depend on the values of Column A -- once a user
selects a value in the list of column A, column B will populate a list
crresponding to the selected value in Column A. There are about 1000
rows in the sheet and for each row, a user has to first select from
Column A list and then Column B list. I have implemented this
funtionality using the method describing here:
http://www.ozgrid.com/News/excel-dependent-lists.htm
Now my boss wants me to do it using macro/VBA. Because the lists in
each cell that I created in the above way are not the control
"listbox", they just appear to be lists. So I don't know how to refer
to a list in a cell and how to program the event when a user selects an
item from the list.
The article mentioned above says this can be done using VBA, but it
doesn't say how. Any suggestions would be highly appreciated!
Column B's values depend on the values of Column A -- once a user
selects a value in the list of column A, column B will populate a list
crresponding to the selected value in Column A. There are about 1000
rows in the sheet and for each row, a user has to first select from
Column A list and then Column B list. I have implemented this
funtionality using the method describing here:
http://www.ozgrid.com/News/excel-dependent-lists.htm
Now my boss wants me to do it using macro/VBA. Because the lists in
each cell that I created in the above way are not the control
"listbox", they just appear to be lists. So I don't know how to refer
to a list in a cell and how to program the event when a user selects an
item from the list.
The article mentioned above says this can be done using VBA, but it
doesn't say how. Any suggestions would be highly appreciated!