Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I run a macro from a event structure?
I have a macro and I can off cause run it from "Alt + F8". But how can I run
the mecro each time the cell B2 is changing value? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I run a macro from a event structure?
On Dec 19, 3:43 pm, SLE wrote:
I have a macro and I can off cause run it from "Alt + F8". But how can I run the mecro each time the cell B2 is changing value? Put following code in your worksheet module: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$2" Then YourMacro End If End Sub If you have more than one cell you could also use a select case statement. hth Carlo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I run a macro from a event structure?
How does B2 get changed?
Manually or by calculation? Event code can be used but type of event is crucial for an answer. Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 22:43:01 -0800, SLE wrote: I have a macro and I can off cause run it from "Alt + F8". But how can I run the mecro each time the cell B2 is changing value? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I run a macro from a event structure?
B2 is changed by calculation.
Let us say B2 is "=B1". If I Manualy change the value in B1, then the value in B2 is changed also. This value change in B2 must create the event that runs the macro. "Gord Dibben" wrote: How does B2 get changed? Manually or by calculation? Event code can be used but type of event is crucial for an answer. Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 22:43:01 -0800, SLE wrote: I have a macro and I can off cause run it from "Alt + F8". But how can I run the mecro each time the cell B2 is changing value? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I run a macro from a event structure?
I've been away a couple of days.
I am surprised you have not received an answer. Try this in the sheet module. Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("B2") If .Value < "" Then Call themacroname End If End With stoppit: Application.EnableEvents = True End Sub Gord On Wed, 19 Dec 2007 22:44:01 -0800, SLE wrote: B2 is changed by calculation. Let us say B2 is "=B1". If I Manualy change the value in B1, then the value in B2 is changed also. This value change in B2 must create the event that runs the macro. "Gord Dibben" wrote: How does B2 get changed? Manually or by calculation? Event code can be used but type of event is crucial for an answer. Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 22:43:01 -0800, SLE wrote: I have a macro and I can off cause run it from "Alt + F8". But how can I run the mecro each time the cell B2 is changing value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
Change event Macro | Excel Discussion (Misc queries) | |||
It seems to me that I need an event Macro, | Excel Worksheet Functions | |||
'Event' macro | New Users to Excel | |||
Event Macro | Excel Discussion (Misc queries) |