userform to refer to active X check boxes in excel

[kosherboy]

i came across an interesting problem:
I am trying to have a user form check an active X check box situated in excel, is this at all possible?
For some reason the user form cannot access the check boxes, my hunch is that user forms have the possibility of having their own check boxes so maybe vba is getting confused?
Any help would be greatly appreciated

[Leith Ross]

Hello kosherboy,

Without seeing the workbook layout and the code you are using, I can not tell you where the problem is.

ActiveX controls placed on a Worksheet belong to the Worksheet as an OLEObject class. You must qualify your references to the ActiveX control using the worksheet's name.

For Example, this will set CheckBox1 to True (Check visible)

Please Login or Register  to view this content.

[mikerickson]

It will work if you refer to the Sheet object by it's code name

Please Login or Register  to view this content.

Although if you are going to be sending this sheet to others, you might want to use Form controls on the worksheet, in case someone has a Mac.

[kosherboy]

Hello kosherboy,

Without seeing the workbook layout and the code you are using, I can not tell you where the problem is.

ActiveX controls placed on a Worksheet belong to the Worksheet as an OLEObject class. You must qualify your references to the ActiveX control using the worksheet's name.

For Example, this will set CheckBox1 to True (Check visible)

Please Login or Register  to view this content.

Hi Leith,
Thank you for your response.
Here is an uploaded example workbook Book1.xlsm, your suggestion works if the action does not depend on "if" statement, please see in my uploaded workbook the following argument "If range G3.value = "TRUE" then have the userform check the active x checkbox", the code doen't seem to be reading this argument hence the checbox is not getting checked.

[kosherboy]

It will work if you refer to the Sheet object by it's code name

Please Login or Register  to view this content.

Although if you are going to be sending this sheet to others, you might want to use Form controls on the worksheet, in case someone has a Mac.

Thank you MikeRickson.
I appreciate your time on this however my goal is to have the userform 'actively' check the activeX checkbox, the message boxes is definetly an interesting way of reading the checkbox but it does not help me in this situation.

[Leith Ross]

Hello Kosherboy,

The problem with is the syntax.

Here is the corrected code. The correction is in blue.

Please Login or Register  to view this content.

[kosherboy]

Wow! So simple!
Thanks

[Leith Ross]

Hello kosherboy,

The difference is "TRUE" is a String type while True is Boolean type. Excel capitalizes TRUE to indicate the value is Boolean but also treats any string value like TURE as a Boolean value.

Hae a guid Hogmany.
Have a good New Year's EVE.

Bliadhna mhath ùr!
Happy New Year!

[kosherboy]

Thank you, that is definitely some helpful info.
Happy New Year's to you as well!