Linking my VB macro to cells?

[jwp]

I may be doing this wrong but if you could help that would be great.

Now I have my VB macro written and I want to link it to several cells. For example A1, A2, and A3.

Is there a way for my macro to run against these cells when data is entered into them?

Hope that is clear. Thank you!

 

[SteveO59L]

Use a worksheet.change event calling your code

 

[Andrew Poulsom]

You can use the Worksheet_Change event procedure (in the module for the worksheet):

Private Sub Worksheet_Change(ByVal Target As Range)
    If Application.Intersect(Target, Range("A1:A3")) Is Nothing Then Exit Sub
'   Your code here
End Sub

 

[Yahya]

Right Click on sheets Name --View Code , then test this code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("A1:A3"), Target) Is Nothing Then
'your code here
End If
End Sub

 

[jwp]

Man this board rocks, you ask a question and get an answer within the hour.

Will test it out and let you know.

Thank you

 

[Andrew Poulsom]

Man this board rocks, you ask a question and get an answer within the hour.

On this occasion, 3 answers in 5 minutes.

 

[Yahya]

On this occasion, 3 answers in 5 minutes.

jwp you are lucky