I've made an example here on creating dependent listing. This may solve
your problem without using macros ... :
http://www.pvv.org/~nsaa/excel.html#24