+ Reply to Thread
Results 1 to 4 of 4

Excel Checkboxes

  1. #1
    Registered User
    Join Date
    04-04-2019
    Location
    Georgia, USA
    MS-Off Ver
    2013
    Posts
    5

    Lightbulb Excel Checkboxes

    I have a entry sheet in a workbook that has a couple macros already in place. I was wondering if it is possible to have a group of check boxes cause the macros to take place.

    I would like to have 5 check boxes and once they all are checked it would call my other marcos.

    I don't have any code written for this at this point many wondering if it would a be worth my time.

    Any help would be awesome! Thanks in advance...

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,165

    Re: Excel Checkboxes

    Yes that's perfectly feasible.

    One way if you're using UserForm Checkboxes. One of their properties is a linked cell where the linked cell will record True or False. Point each checkbox to one of cells say A1:A5 and in another cell use
    =COUNTIF(A1:A5,True)

    and name this cell say 'Check'

    Now assign the macro below to each of the check boxes, and substitute your macro name where it says 'YourMacroName'

    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-04-2019
    Location
    Georgia, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: Excel Checkboxes

    It isn't counting my checkboxes?

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,165

    Re: Excel Checkboxes

    Sorry, that line of code should have read

    If Range("Check") = 5 Then

    assuming you have 5 check boxes

    Upload the workbook if you still have aproblem
    Last edited by Richard Buttrey; 05-10-2019 at 04:13 AM.

+ 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. hiding rows which contain checkboxes but checkboxes don't hide as they should
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-08-2019, 10:26 AM
  2. Using Checkboxes to control other sets of checkboxes
    By Entregan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2018, 01:59 PM
  3. [SOLVED] Checkboxes - How to check/uncheck other checkboxes based on another checkbox
    By brooklyn_87 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-27-2017, 01:20 PM
  4. [SOLVED] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  5. master checkboxes to select a group of other checkboxes?
    By fael097 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-26-2016, 03:46 PM
  6. Replies: 4
    Last Post: 04-28-2013, 12:47 AM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 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