Because it is worksheet event code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

If you need help in writing the macro, just update this post.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Thanks for the replies. I don't know how to create a event macro. Could you
walk me through it. Where do I find the button for event macro? In which tool
bar is it in?

Thanks

"Gary''s Student" wrote:

Yes it is possible.

You would create a event macro that would monitor the formula in A2 and,
depending upon the result, change the contents of A1.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance