sindrefm
01-08-2015, 12:48 AM
Hi,
I want to use a check button, or any kind of toggle buttons, to enable and disable lines of code.
What I have done is the following:
Sheet2:
Private Sub CheckBox21_Click()
CodeLine = False
End Sub
Module1:
Sub Test()
Dim CodeLine As Boolean
CodeLine = True
If CodeLine = True Then
If .... then
End if
End if
End sub
To get this working like I have described, where should I place the CodeLine = True, to get the Checkbutton enable the False criteria right?
I want to use a check button, or any kind of toggle buttons, to enable and disable lines of code.
What I have done is the following:
Sheet2:
Private Sub CheckBox21_Click()
CodeLine = False
End Sub
Module1:
Sub Test()
Dim CodeLine As Boolean
CodeLine = True
If CodeLine = True Then
If .... then
End if
End if
End sub
To get this working like I have described, where should I place the CodeLine = True, to get the Checkbutton enable the False criteria right?