Hi, I have made some drop down menus using the data validation technique. This is a three tier system and it works perfectly fine. However I have decided to add a combo box overlay that appears on double click using the code below. This works for the first set of drop downs, but not the second and third tier (I'd imagine because they use INDIRECT, within the sourcing). I have attached the file that I am working with, any help is appreciated.
I have tried using the following, to convert the "indirects" to proper cell references but have had no luck.