+ Reply to Thread
Results 1 to 5 of 5

How to see the ActiveX Checkbox is checked ?

  1. #1
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    How to see the ActiveX Checkbox is checked ?

    I have a ActiveX checkbox I created from the Developer/Insert Menu. In VBA, I would like to see if the check box is checked and if it is run a certain code and if it is not checked run another section of code. The checkbox is located in the PA_Running_Sheet_A worksheet in cell C17. When I check that box I get an error message. Does anyone know what I am doing wrong?
    My code is in Sheet2 and the error messages says Complie error: Expected Function or Variable

    Thanks

    redsab
    Attached Files Attached Files
    Last edited by redsab; 09-17-2013 at 05:56 AM.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: How to see the ActiveX Checkbox is checked ?

    Change that line to :
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: How to see the ActiveX Checkbox is checked ?

    millz,

    Thanks for your help! That did the trick. I seem to have another problem with my sheet and thought you might know what's wrong! When you click on the ActiveX CheckBox that is in cell B34, labled All, it should check all of those lower boxes. Also if you uncheck the same button it should uncheck all of those lower buttons. It does that, but it also seems to run the CheckBox13 which is the one we were just looking at. It should not do that, do you have a clue why it is running CheckBox13_Click procedure? Or should I do a seperate post on that question?

    Thanks,

    redsab
    Attached Files Attached Files

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: How to see the ActiveX Checkbox is checked ?

    try changing the code for that "All" checkbox to:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: How to see the ActiveX Checkbox is checked ?

    millz,

    Great idea, thnaks again! That works! Your the best!!

    redsab

+ 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. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  2. [SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-25-2013, 03:10 AM
  3. [SOLVED] ActiveX Checkbox entering a value when checked or unchecked
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 02:59 PM
  4. VB checkbox checked?
    By prowsdower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2009, 12:05 PM
  5. How to have Checkbox A uncheck with checked Checkbox B
    By Texas Aggie 09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2007, 09:29 AM

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