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?

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?