I added some click buttons to Xcel sheet and link it to a cell say M169...

and I wrote this in VB:

If (Target.Address = "M169") Or (Target.Address = "$D$173") Or(Target.Address = "$D$175") Then
etc...

When I click the buttons, the Xcel sheet is not updated automatically.

How can I go about solving this problem?

I am still fairly new to VB.

Thanks for any help.