Error 424 on script to change the status of a ActiveX checkbox based on a cell value

Dear Community:
I'm new at coding on vba excel and have looked at a bunch of threads but I don't find an answer that fits my problem. Hope someone could help me please.
I'm attaching the workbook that I'm trying to use.

By default, the cell G8 has a value of "Please select the Probability". After we click the command button "Calculate Probability", a form pops up, we need to provide answers to the questionnaire and click on the button "Calculate".
With the button, a calculation begins and the results affects the content of cell G8 and it triggers the CheckBox to be enabled. The condition to enable the CheckBox is that the content of the G8 cell must be different from "Please select the Probability".

Here is the code:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


This is error I'm getting (the line above in bold is the one where I'm getting the error)

Run-time error '424'
Object required

Thanks in advance!

This worked for me....

Please Login or Register  to view this content.

The code you show in your post is not the same as the code that is actually in the file, at the place where the error occurs. The error occurs in Sub CalculateProb_Click:

Please Login or Register  to view this content.

If you add the dots in front of CheckBox1 in your code then it will work.

You're welcome and thanks for the rep!