I am Running Excel 2010 on a Windows 7 computer. Both are fully updated.
I am trying to build a statement that when a cell has a certain text in it that it will automatically run a macro that I have defined. The macro works fine, but I can not get it to run automatically when the field is either filled in or changes.
The statement should work like this- If cell C3 has red in it, then run macro Reddish, If C3 has green in it, then run macro Greenish, etc. for 5 nested conditions.
Thank you in advance. s
I am trying to build a statement that when a cell has a certain text in it that it will automatically run a macro that I have defined. The macro works fine, but I can not get it to run automatically when the field is either filled in or changes.
The statement should work like this- If cell C3 has red in it, then run macro Reddish, If C3 has green in it, then run macro Greenish, etc. for 5 nested conditions.
Thank you in advance. s