I have two validations (A1 and A2).
A2's validation is dynamic as it's selectables varies based on the selection made by the A1 Validation. (=indirect(a1)).
My problem is this....once if have selected from both validations...if I go back and change the A1 validation to a blank (or empty value) or clear the contents on that cell....validation A2's value remains as it was. I would like it to recognize that A1 is blank and also become blank (or goto an empty value).
Any suggestions?
Last edited by GuruWannaB; 11-11-2008 at 03:29 PM.
If I am unable to have a macro initiated by a change in validation...Could one be initiated by a checkbox? Just looking for a solution or an alternative method. =)
Ok....I figured it out with a little help on some similar code I found - so here is the answer:
Right click on the tab - click on view code
Paste:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks