Calling Macro from cell selection

[dkatorza]

Hi,

I'm having problem with when trying to call Macros from cell selection/value.
attached test sheet for reference.

The code i'm using :

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address(True, True) = "$J$7" Then
Select Case Target
Case "SRG PER W/M"
Call ADDSRGWMLINE
Case "SRG PER TON OR PART OF IT"
Call ADDLOCALPERTON
Case Else
'Do nothing
End Select

End If
End Sub



Thank you very much.

[TMS]

The cell content does not match what you are testing for in the code. It has more spaces: "SRG PER W/M" as opposed to

Please Login or Register  to view this content.

And do you actually mean Selection Change or Change. There is a difference.

You also need to switch off event handling when you are going to change things within a Change Handler or select things in a Selection Change Handler.


Regards, TMS