Hey, first time poster here for you guys. I am pretty good w/ Excel, except for the VBA aspects of it. But this should be an easy one for you guys...
I want to clear the value of a cell based on if a different cell is false. The cell to be cleared is a Validation List, but I want the default to be blank based upon the value of a seperate cell (located in another worksheet). Example.
If cell C7 in WorkSheet1 = false, then cell K17 in WorkSheet2 should be cleared.
Another option. I have a macro (called DeleteK17) set up to clear cell K17 in WorkSheet2. Is there a way to run the macro if cell C7 in WorkSheet1 = false?