Hello all,
I am a newbie and in need for some help related to this.</SPAN>
I am using a DTpicker pointed to linkedCell “L10”.</SPAN>
I want to run a macro every time a user selects any date at all ... and therefore changing the cell “L10”.</SPAN>
I have found in other threads people were using this code:</SPAN>
Private Sub Worksheet_Change(ByVal Target As Range)</SPAN>
If Not Intersect(Target, Range("L10")) Is Nothing Then</SPAN>
MsgBox "A1 value is changing"</SPAN>
End If</SPAN>
End Sub</SPAN>
The thing is: this code only works when the user actually types something ... It has no effect when the cell is changed by the DTpicker.</SPAN>
Any ideas? </SPAN>
Please....</SPAN>
Thx a lot,</SPAN>
Rafael</SPAN>
I am a newbie and in need for some help related to this.</SPAN>
I am using a DTpicker pointed to linkedCell “L10”.</SPAN>
I want to run a macro every time a user selects any date at all ... and therefore changing the cell “L10”.</SPAN>
I have found in other threads people were using this code:</SPAN>
Private Sub Worksheet_Change(ByVal Target As Range)</SPAN>
If Not Intersect(Target, Range("L10")) Is Nothing Then</SPAN>
MsgBox "A1 value is changing"</SPAN>
End If</SPAN>
End Sub</SPAN>
The thing is: this code only works when the user actually types something ... It has no effect when the cell is changed by the DTpicker.</SPAN>
Any ideas? </SPAN>
Please....</SPAN>
Thx a lot,</SPAN>
Rafael</SPAN>
