Excel - Cell Event (th formula in cell)

Closed
sswcharlie
Posts
1
Registration date
Friday July 17, 2009
Status
Member
Last seen
July 18, 2009
- Jul 18, 2009 at 03:24 PM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jul 20, 2009 at 01:38 AM
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

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 20, 2009 at 01:38 AM
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
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jul 18, 2009 at 08:06 PM
as far I know there is no cell event but only worksheet event and workbook event. please rephrase what you wnt somebody can help
0