Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event Refuses to Action
Hello,
I have created the following code in the Worksheet / Change section of Objects (as opposed to in Modules): Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$j$12" Then Call microbusiness End If End Sub However, when I make a change in the cell j12, it does not call my macro as it should. Is there something I am doing wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event Refuses to Action
Hi
Try a capital J. I never realised lower case was a problem either! regards Paul On Jun 19, 10:22*am, Darren wrote: Hello, I have created the following code in the Worksheet / Change section of Objects (as opposed to in Modules): Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$j$12" Then Call microbusiness End If End Sub However, when I make a change in the cell j12, it does not call my macro as it should. Is there something I am doing wrong? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event Refuses to Action
Targets are case-sensitive.
:) susan On Jun 19, 5:32*am, wrote: Hi Try a capital J. I never realised lower case was a problem either! regards Paul On Jun 19, 10:22*am, Darren wrote: Hello, I have created the following code in the Worksheet / Change section of Objects (as opposed to in Modules): Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$j$12" Then Call microbusiness End If End Sub However, when I make a change in the cell j12, it does not call my macro as it should. Is there something I am doing wrong?- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Event Refuses to Action
On Jun 19, 10:18*pm, Susan wrote:
Targets are case-sensitive. :) susan On Jun 19, 5:32*am, wrote: Hi Try a capital J. I never realised lower case was a problem either! regards Paul On Jun 19, 10:22*am, Darren wrote: Hello, I have created the following code in the Worksheet / Change section of Objects (as opposed to in Modules): Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$j$12" Then Call microbusiness End If End Sub However, when I make a change in the cell j12, it does not call my macro as it should. Is there something I am doing wrong?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Thank you both. I could have looked at this problem all day long and not thought of that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Event duplicating action | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Worksheet change event I think? | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |