How to program dependent list in Excel using VBA?

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!

Does this help

http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"swu012" <[email protected]> wrote in message
news:[email protected]...
> 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!
>

Hi Bob,

It absolutely helped! It's exactly what I was looking for and it's a
life-saver! Thanks a million!