Impacting a cell

[Erol]

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

 

[Mike H]

Erol,

Formula cannot 'push' data, they can pull data so without a formula in A1 it
isn't possible to do what you want without resorting to code.

If you explain with more detail what you want then someone will help.

Mike

 

[Gary''s Student]

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.

 

[Erol]

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]

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.