Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger VBA routine if ceel content changes
I need to trigger a VBA routine when the content of one specific cell in a
sheet changes. Can anybody point me in the right direction? Thanks for your time. Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger VBA routine if ceel content changes
You will need to use the Worksheets Change Event .... Right click the sheet tab name and select View Code.... Paste code something like Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then RunYourMacroName End If End Sub Just change the cell Address you need to monitor the change in. -- Ivan F Moala ------------------------------------------------------------------------ Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954 View this thread: http://www.excelforum.com/showthread...hreadid=273093 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger VBA routine if ceel content changes
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target 'do something End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP "Daniel Van Eygen" wrote in message i.nl... I need to trigger a VBA routine when the content of one specific cell in a sheet changes. Can anybody point me in the right direction? Thanks for your time. Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
SUB ROUTINE | Excel Programming | |||
Routine?? | Excel Programming | |||
How to code a timer to trigger a sub-routine ? | Excel Programming | |||
Need VBA Routine | Excel Programming |