Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on Calculation event
Is there such a thing as onCellupdate. I am using Worksheet_Calculate(
but my actions within that create new data and so keep looping. Is i posible to react to just the change of data on one cell. I am using RTD from another application and so data change often. Please help if you can. -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
on Calculation event
You can stop the looping by wrapping your code with
Application.Enableevents: Private Sub Worksheet_Calculate() Application.EnableEvents = False 'Do stuff Application.EnableEvents=True End Sub In article , grievesy wrote: Is there such a thing as onCellupdate. I am using Worksheet_Calculate() but my actions within that create new data and so keep looping. Is it posible to react to just the change of data on one cell. I am using RTD from another application and so data change often. Please help if you can.. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
on Calculation event
Put this in the worksheets' object codemodule: Private Sub Worksheet_Change(ByVal Target As Range) 'this will trigger within specified range If Target.Count = 1 And Intersect(Target, Me.Range("a30:c300")) Then 'temporarily prevent triggering further events Application.EnableEvents = False Target.Cells(1, 1) = Target.Cells(1, 2) Application.EnableEvents = True End If End Sub keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool grievesy wrote: Is there such a thing as onCellupdate. I am using Worksheet_Calculate () but my actions within that create new data and so keep looping. Is it posible to react to just the change of data on one cell. I am using RTD from another application and so data change often. Please help if you can.. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
on Calculation event
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Event Procedures: Event on Worksheet to fire Event on another Worksheet | Excel Programming | |||
change event/after update event?? | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |