Hi, try googling 'dependent validation lists'. Normal examples assume you will have A list, B list, etc. in consecutive columns, although this can be addressed.
Let us know if that helps or you get stuck.


Sorry, I note from the title you're using ActiveX drop-downs. The same logic as outlined in dependent validation lists can easily be used to set the rowsource for an activex combobox or listbox based on entry/selection in other controls or the sheet itself.