Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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