Posted to microsoft.public.excel.programming
|
|
how do I: launch a macro if two cells do not equak one another?
"jasonsweeney " wrote in
message ...
John,
Lets assume Cell #1 has the value "3" in it.
Lets also assume Cell #2(different sheet) also has the value "3" in
it.
I am concerned when a user changes the value of Cell #1 to anything
other than "3". Thus, when a user click in the cell, and changes the
value of Cell #1 to "1", I want the macro to fire once they press
enter, or click out of the cell. Thus, I assumed Worksheet change was
the correct event. But nothing happens in my code......
---
Message posted from http://www.ExcelForum.com/
|