Reply to thread

Message: [QUOTE="Leo, post: 7419409"] Hello, can anyone help me with the following. I have a module in vba in which I give a certain boolean the value True. It is a public variable with the name blnStop (Public blnStop as boolean). If the value is True then the code under the worksheet_change should not work: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If blnstop = True Then Exit Sub If Target.Column = 7 Or Target.colums = 14 Then ...... End Sub Somehow the value of the boolean blnstop (which is True) is not passed to this event. In this event the boolean has the value False. Can anyone help me with this please. What am I doing wrong? [/QUOTE]