I want to define the state of a checkbox based on an If/Then test in a macro.
If Sheets("Rnd " & RoundsFlown - 1 & "").Range("X49") > 0 Then
Checkbox14 = True
The statement in this macro has no effect. The command "Checkbox14 = True" works fine when the command is contained within the code defining the function of other checkboxes.
I have tested the functionality of the command within a macro by writing a very simple macro consisting of nothing more than "Checkbox 14 = True" which the running of also has no effect.
Please tell me what I am missing.
IEQFDave
Bookmarks