+ Reply to Thread
Results 1 to 6 of 6

ActiveX Checkbox Not Working

  1. #1
    Forum Contributor
    Join Date
    05-17-2017
    Location
    Tallahassee
    MS-Off Ver
    15.32
    Posts
    206

    ActiveX Checkbox Not Working

    Hi everyone,

    The following code is supposed to create a new chart every time I checkoff my ActiveX checkbox, however, I have to constantly check and un-check it for it to work. See attached for my workbook and below if you only want the code. I want to be able to just click a cell and "updatechart" to be automatically called. Any help is appreciated


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: ActiveX Checkbox Not Working

    Hello EdwardSnowden,

    Here is the working code...

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    05-17-2017
    Location
    Tallahassee
    MS-Off Ver
    15.32
    Posts
    206

    Re: ActiveX Checkbox Not Working

    Leith,

    I appreciate the help, however, it is giving me the same results as the original code. Let me know if I am just doing this incorrectly:

    After replacing my old code with your code, I un-check and then recheck the check box. Immediately, the message box appears with the message "Selection Out of Range" which is accurate since it is out of range. Sadly, when I click any other cell, nothing is happening even though the check box remains checked.

    Am I doing something wrong?

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: ActiveX Checkbox Not Working

    Hello EdwardSnowden,

    The macro worked on my computer. So I have to suspect that something on your end is different.

    Did you protect the worksheet or workbook?
    Did you move any data on the worksheet?

  5. #5
    Forum Contributor
    Join Date
    05-17-2017
    Location
    Tallahassee
    MS-Off Ver
    15.32
    Posts
    206

    Re: ActiveX Checkbox Not Working

    Leith,

    The problem is I misread your code. It does work. I didn't realize I needed to remain within column B. This works beautifully and I understand the code as well. Much appreciated!

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255

    Re: ActiveX Checkbox Not Working

    Hello EdwardSnowden,

    Your Welcome. Glad I could help.

+ 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. ActiveX Checkbox to make Date Picker visible not working reliably
    By myersjster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2017, 12:43 PM
  2. Programmatically name a activex CheckBox
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2015, 11:21 PM
  3. [SOLVED] setting activex checkbox properties
    By MATT.B in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2015, 06:27 PM
  4. Replies: 1
    Last Post: 07-27-2014, 10:57 AM
  5. [SOLVED] ActiveX Control Checkbox
    By danex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 09:22 AM
  6. [SOLVED] How to see the ActiveX Checkbox is checked ?
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2013, 04:37 AM
  7. Hide ActiveX Checkbox on worksheet
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2011, 04:46 PM

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