Search : in
By :

Excel - Cell Event (th formula in cell)

Last answer on Jul 20, 2009 6:38:10 am BST sswcharlie, on Jul 18, 2009 8:24:56 pm BST 
 Report this message to moderators

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

Configuration: Windows XP
Firefox 3.0.11

Best answers for « Excel Cell Event (th formula in cell) » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Inserting an Hyperlink in an Excel Worksheet ShowCreating an Hyperlink in an Excel Worksheet Introduction Implementation Linking to a Website Linking to a document Linking to another cell in the spreadsheet Notes Introduction Excel supports the use of hyperlinks and it is a very...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

venkat1926, on Jul 19, 2009 1:06:21 am BST

As far I know there is no cell event but only worksheet event and workbook event. please rephrase what you wnt somebody can help

   
Reply to venkat1926

2

 Excelguru, on Jul 20, 2009 6:38:10 am BST

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.
Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru
Ask your question Reply
They need your help