Thread: Can you use VBA to mark selected/deselect activeX control check box?

I have an ActiveX Control check box located on Sheet1 called Checkbox4.

This checkbox has small procedures tied to it that run onced mark as being "selected" or "unselected" or "checked" and un-checked" (however you look at it).

And these small procedures runs just fine when the user does indeed click on the check box - BUT My current VBA code ISNT marking them as being true or false with simply:

Sheet1.Select
CheckBox4 = False

or

Sheet1.Select
CheckBox4 = True

I have this located within a if statment that uses the answer from a vbYesno message box.

Hello clemsoncooz,

The syntax for ActiveX objects on a worksheet is a little more complex. This example will "check" the control. Set the value to false to clear the "check".

Worksheets("Sheet1").OLEObjects("CheckBox4").Object.Value = True

Perfect! Thank you!