Hi, using the code below i have implemented an automated drop down system (ON DOUBLE CLICK), this code is meant to clear the dependent cells if the first one is changed... i.e. on the test spreadsheet If i had, say Tuesday and chips selected and then changed the Tuesday to Wednesday it will clear. This works when you press enter after changing the first cell... however this doesn't work if you change the first cell and then simply click off of it (on any cell). I've tried messing about with the code but I am unsure how to do it. Any Help is appreciated, thanks.
Bookmarks