My goal is that A2 is not allowed to equal B2 and A3 cannot equal B3 and so on and so forth. This would be perfect if I could use data validation in order to get my error message, however dv only worked after I went into a cell that had a "a" and clicked enter.
It is predicated on the following vba code (not mine) therefore if a cell is double clicked it will populate an "a" in marlett font, which shows up as a ✓
Would it be possible to have the above code be contigent upon if the cell adjacent to the active cell is "" then target.value = "a" I believe this would be difficult because the active cell could be in column A or B and then the adjacent cell would be B or A.
If that code was possible then there would be a corresponding error message if there was an "a" in A2 and I double clicked B2 or visa a versa.
Thanks in advance for your help!
Bookmarks