amarokWPcom
New Member
- Joined
- May 30, 2019
- Messages
- 25
I have a toll as a Workbook.
All my subroutines are in a reference (read-only) on the server, so my team membershave access with their tools to use the subroutines.
In my tool I want to use If..then decisions declared by checkboxes.
Unfortunately all of this is not working and I don't understand why:
F.e. the Checkbox is on
Worksheet("UI")
the Checkbox is named
CheckBox2
the text in the checkbox is
Test Mode
in the function field is written
=EMBED("Forms.CheckBox.1";"")
Why this is all not working AND what the hell is working to check the value of the box ?
If Worksheets("UI").OLEObjects("CheckBox2").Value = True Then...
If Worksheets("UI").Shapes("Test Mode").ControlFormat.Value = True Then...
If Worksheets("UI").Shapes("Test Mode").OLEFormat.Object.Value = True Then...
If Worksheets("UI").CheckBoxes("Test Mode").Value = True Then...
All my subroutines are in a reference (read-only) on the server, so my team membershave access with their tools to use the subroutines.
In my tool I want to use If..then decisions declared by checkboxes.
Unfortunately all of this is not working and I don't understand why:
F.e. the Checkbox is on
Worksheet("UI")
the Checkbox is named
CheckBox2
the text in the checkbox is
Test Mode
in the function field is written
=EMBED("Forms.CheckBox.1";"")
Why this is all not working AND what the hell is working to check the value of the box ?
If Worksheets("UI").OLEObjects("CheckBox2").Value = True Then...
If Worksheets("UI").Shapes("Test Mode").ControlFormat.Value = True Then...
If Worksheets("UI").Shapes("Test Mode").OLEFormat.Object.Value = True Then...
If Worksheets("UI").CheckBoxes("Test Mode").Value = True Then...