VBA worksheet change based on two list fields

[dusoo]

Hi guys,

how can I achieve that macro will be executed when something changes in two separate cells.
Now it is working only for cell A1
How can I change this code to execute the macro when I change value also in cell B1?
Adding new If Target.Row line did not do anything...

Thanks

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
MsgBox ("I'm here")
...

[wenqq3]

Please Login or Register  to view this content.

Hope this okie for you :D

Please Login or Register  to view this content.

Edit, above work as well!

[dusoo]

Thanks, It was even easier then I thought

[wenqq3]

Welcome :D Thanks for feedback!!