multiple worksheet change events

[mikejaco]

Hello,


I have little experience with vba but have used some simple code in some workflow sheets.

I have used the following worksheet change event code successfully but I am having problems figuring out how to add two more cells to be monitored. They will all have the result of running the same macro.

Any help would be appreciated.

[pre]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 And Target.Row = 46 Then
Call Skidtag
End If
End Sub

[/pre]

 

[shrivallabha]

Hi Mike,


Welcome to Chandoo.org.


Currently the event fires for cell C46. Assuming you want it to fire for C48 and C50, try like this:

[pre]

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$46", "$C$48", "$C$50"
Call Skidtag
End Select
End Sub

[/pre]

Note to moderators: I have repeatedly attempted to post in this thread. There would be some posts related to this thread. Request you to delete them.

 

[mikejaco]

This solution works great and is simple enough for me to understand. Thank you very much for your help.