Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating a macro after a cell is updated
Hello All!!
I need help to activate a macro after the user finishes updating a cell. Can this be done? Will it use up alot of the memory resources? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating a macro after a cell is updated
Right click on a sheet tab, select view code and put in code like this.
Assume your macro (Macro1) should run when the user edits cell B9 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$9" then if not isempty(Target) then macro1 end if End if End Sub -- Regards, Tom Ogilvy "mecg96" wrote in message ... Hello All!! I need help to activate a macro after the user finishes updating a cell. Can this be done? Will it use up alot of the memory resources? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
Run Macro(save workbook) after cell updated | New Users to Excel | |||
Run a macro when a cell is updated | Excel Programming | |||
Macro not running when cell value is updated | Excel Programming | |||
Cell Change activating macro. How do you make it happen? | Excel Programming |