I am wanting simply reset or clear the contents on the data validation everytime the linked cell changes. Example if the user enters something in cell A1 the data validation in cell B1 will reset meaning if something was already in the cell have the program reset it to 1) Either blank or 2) The first value in the data validation. I pasted my example code below

Also is there a way to actually get the data validation list to display without clicking the dropdown arrow. In my case once something is entered in lets say cell A1, then cell B1 becomes activate (target.offset(0,1).activate) then the arrow displays. But is there a way to actually get the list to display without clicking the arrow. 

Please Login or Register  to view this content.