Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on cell entry
i want a macro to run after a number (any number) has been entered into a
cell i.e a2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on cell entry
In the VBE window, right click the sheet and view code. Change "(General)" to "Worksheet" in the top left drop down box, and choose "Change" in the top right. Yopu should see: Private Sub Worksheet_Change(ByVal Target As Range) End Sub In the main window. Between these two lines put this: If Target.Address = "$A$2" And WorksheetFunction.IsNumber(Target.Value) = True Then Call YourMacro() Changing "YourMacro()" to the relevant macro. "sleemo" wrote: i want a macro to run after a number (any number) has been entered into a cell i.e a2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on cell entry
thanks
i just had to add end if and worked great "sleemo" wrote: i want a macro to run after a number (any number) has been entered into a cell i.e a2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a macro when there is a given cell entry | Excel Programming | |||
Macro Run on Cell Entry | Excel Discussion (Misc queries) | |||
Macro to copy text upon entry into cell | Excel Programming | |||
Macro to force cell entry before running | Excel Programming | |||
Macro execution linked to cell entry | Excel Programming |