+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    05-12-2021
    Location
    M憖ico
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13530.20054)
    Posts
    17

    Unhappy 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!
    Attached Files Attached Files
    Last edited by 6StringJazzer; 05-13-2021 at 10:25 AM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

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

    This worked for me....

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

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

    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.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    05-12-2021
    Location
    M憖ico
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (16.0.13530.20054)
    Posts
    17

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

    Quote Originally Posted by 6StringJazzer View Post
    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.
    Thank you so much! This was the mistake I was making, thanks for the enlightenment!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

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

    You're welcome and thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable ActiveX checkbox based on Value
    By hnguy71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2018, 01:04 PM
  2. Replies: 3
    Last Post: 02-12-2015, 11:42 AM
  3. [SOLVED] Use VBA to change worksheet tab color based on ActiveX checkbox values
    By penny in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2015, 02:12 PM
  4. Filter table based on ActiveX Checkbox
    By mcmahobt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:58 PM
  5. [SOLVED] Increment through Checkbox's to check status and change a value
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2014, 04:07 PM
  6. [SOLVED] Easy Macro needed to change some, not all, activeX checkbox to False or True
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2014, 12:51 PM
  7. Using ActiveX CheckBox Control to make a cell change colour and clear values
    By drmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2012, 04:18 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1