William C Johnson
asked on
CheckBox Not Recognized as True When Checked
Can someone tell me why these check boxes don't work? The macro does not seem to recognize when a check box is True? It immediately goes to the Else condition. This series of macros starts with the Begin macro.
Grocery-List-.doc
Grocery-List-.doc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That is not the reason.
You can have the same variable name in different subs or forms.
Each refer only to the sub they are in, unless directly specified otherwise.
That is why I suggest you use Option Explicit at the top of each module (or form) so that all variable must be declared.
Then when compiling, the not specified names will be found before runtime.
It makes coding easier, type the beginning of the name, and press Ctrl+Space, and you will get a list of possible names to use, or if only one, VBA will insert the name.
And typing errors will not result in another variable.
You can have the same variable name in different subs or forms.
Each refer only to the sub they are in, unless directly specified otherwise.
That is why I suggest you use Option Explicit at the top of each module (or form) so that all variable must be declared.
Then when compiling, the not specified names will be found before runtime.
It makes coding easier, type the beginning of the name, and press Ctrl+Space, and you will get a list of possible names to use, or if only one, VBA will insert the name.
And typing errors will not result in another variable.
ASKER