Fire Macro from Cell Change
Hi,
Yes I have 3 possible conditions.
One is cell f27 changes from " " to anything but it will be numerical,
it fires Rockwell_AddC
One is cell k27 changes from " " to anything but it will be numerical,
it fires Rockwell_RemoveC
and the last condition is if both keycells change, it fires macro
Rockwell_both
Cheers,
Aaron.
Carim wrote:
Hi,
If I may suggest something :
first step is to clarify your matrix of 9 possibilities to determine
macro to be called ...
then, you will adopt the most efficient path ...
HTH
Carim
|