Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
How do I pass a value from an event back to my VBA Programming enviornment. | Excel Programming | |||
Pass a variable to a different sub | Excel Programming | |||
Pass a Variable from one sub to another sub | Excel Programming | |||
Pass Variable to another Sub | Excel Programming |