| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run macro if cell value changes
Hey GS, thankyou for that. Do you mean like this (cos the second one still
doesn't work with this): Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C63")) Is Nothing Then Application.EnableEvents = False Application.Run "Calculate_Stamp_Duty_NEW_HOME" Application.EnableEvents = True End If If Not Intersect(Target, Range("D9")) Is Nothing Then Application.EnableEvents = False Application.Run "Calculate_Stamp_Duty_PROPERTY_3" Application.EnableEvents = True End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Run Macro from a Cell | Excel Worksheet Functions | |||
| Macro for cell selection starting with Last Cell | Excel Worksheet Functions | |||
Threaded Mode
