Excel - Cell Event (th formula in cell) [Closed]

Report
Posts
1
Registration date
Friday July 17, 2009
Status
Member
Last seen
July 18, 2009
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I want a cell event to run a small macro. Have tried the normal cell event code, it works ok when I type in a cell that runs the event, but when I try in the cell that already has a formula, it does not work.

The reason it will not work is that there is a formula in the cell already.

Is there code that allows cell event to work with a formula in the cell already, or somehow copy into a new cell the result ofthe code without being a formula ?

Thanks

Charlie

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello sswcharlie

If you can paste the code , on what cell event you want the macro to run and what your macro is intended to do, then it will be easier to find the solution.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
as far I know there is no cell event but only worksheet event and workbook event. please rephrase what you wnt somebody can help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!