I am trying to create dependent lists in order to restrict users to select only from a drop-down list. For example using Category, Type and Item (CTI):

Category: Hardware and Software.

Hardware Type: Server, Workstation or Peripheral

Software Type: OS, Boxed Application or Developed Software

Items for Workstation Type: Laptop, Desktop, Palmtop
Items for Peripheral Type: Printer, Screen, Scanner, Modem
and the list grows on ...

What should happen is that when a user select Category - Hardware, the user should only be able to select Server, Workstation or Peripheral in the Type drop-down list. When the Type Peripheral is selected the user should only be able to select Printer, Screen, Scanner or Modem in the Item list.

I have found instructions on http://www.contextures.com/xlDataVol02.html how to set up such a list but it does not work they way we want it to work.

One should be able via VBA code and a change event on the drop-down list to do this. Manually creating filters works 100% but we want to use drop-downs. Anybody done this before? Can you perhaps point me to a page for an example?