Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trigger help
Hi, I want to trigger a script whenever the data changes in a cell. For testing purposes I used this little script: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("c1")) Is Nothing Then Range("a1") = 1 End If End Sub The problem: If I type something in c1 everything goes ok But when I put this in c1= e1 and change the data in e1, c1 changes but nothing happens to a1 How can I trigger the script thru a link that changes? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=507589 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trigger help
Use the Worksheet_Calculate method instead.
Or, run the _Change method off of the input to your cell (e.g., E1 in your example) In article , climax wrote: How can I trigger the script thru a link that changes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does using @SUM in EXL 2002 trigger an O/L "new" email ? | Excel Worksheet Functions | |||
trigger problem | Excel Discussion (Misc queries) | |||
Is there a way to trigger pop-up notices in excel? | Excel Discussion (Misc queries) | |||
MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions |