+ Reply to Thread
Results 1 to 9 of 9

Activex button counts to different cells if check box is true

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    20

    Activex button counts to different cells if check box is true

    Hey everybody

    I am struggling with my Excel sheet.
    I have made an Activex button, it counts when I click on it with +1 in cell A19
    This is just so I can see that it has registered my click on the button.

    I have done this with the following Visual Basic code:
    Please Login or Register  to view this content.
    Now I want the activex button to count in other celles, if one of my 5 control elements are true.

    Let me explain :-)

    I have made 5 control elements (check boxes)

    If check box 1 is true, then I will have the activx button to count to cell A1

    If check box 1 is true, then I will have the activx button to count to cell A2

    And so on.

    Can this be done?

    I hope you can help me, best regard

    Soren
    Last edited by Fotis1991; 10-04-2013 at 01:21 PM. Reason: Pls use code tags around your code as per forum rules.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Activex button counts to different cells if check box is true

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: Activex button counts to different cells if check box is true

    Excel problem eng.jpg
    Hey MickG and others

    First of all thanks SO much for your quick answer.

    I am very very sorry, but I am not that good at understanding coding.
    I have tried to put your code in my Excel but I must be doing something wrong.
    I have attached a picture of what my Excel looks like, maybe you have alrady answered my qustion but I can't get it to work.
    Hope you will help me Again.

    Best Regards
    Soren from Denmark

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Activex button counts to different cells if check box is true

    Try this Example workbook.

    Regrds Mick
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: Activex button counts to different cells if check box is true

    Hey MickG

    I can not tell you how HAPPY i am that you have helped me with that.
    THANKS SO SO SO much.

    Soren Denmark

  6. #6
    Registered User
    Join Date
    10-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: Activex button counts to different cells if check box is true

    Hey MickG

    In your Excel sheet, the checkboxes you have made, they are activex checkboxes, right?

  7. #7
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Activex button counts to different cells if check box is true

    Yes, that correct. I was going to mention that in case you had used "Forms".
    Thank you for your response
    Regrds Mick

  8. #8
    Registered User
    Join Date
    10-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: Activex button counts to different cells if check box is true

    It WORKS it WORKS JUBBIIIIIII :-)

    Thanks again

  9. #9
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Activex button counts to different cells if check box is true

    You're welcome
    Kind Regrds Mick

+ 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. Check values of two cells and x if true?
    By mikaselm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 09:16 PM
  2. [SOLVED] Vba code to fill check in & check out counts
    By ashfaquebwd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 09:02 AM
  3. ActiveX Checkbox = True then Copy 2 cells to other Sheet
    By kyros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2012, 07:49 AM
  4. Check if two cells are equal and copy,paste cell if true
    By solomeros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2011, 01:22 AM
  5. [SOLVED] How do I make a check box highlight cells if true?
    By BrianXJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2006, 09:30 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