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 responses

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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses