+ Reply to Thread
Results 1 to 4 of 4

One checkbox that selects multiple checkboxes

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Everett, Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    One checkbox that selects multiple checkboxes

    I am creating a checklist spread sheet. I do not have any experience with VB, so I am unsure as to what code to write to do this: I created many check boxes, but I want to designate one check box that can select multiple check boxes when clicked and deselect check boxes when clicked again (unclick). I have seen other codes for this, but I have no clue as to conform other written codes to my worksheet. An easy step by step guide would be great instead of a copy and paste this code please.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: One checkbox that selects multiple checkboxes

    Welcome to the forum.
    We only help on certain problems not to create a worksheet for you..
    You should start first then if you encounter a problem on the worksheet it's the the time to ask a question to fellow members.
    Thanks.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    Everett, Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: One checkbox that selects multiple checkboxes

    I do not remember asking for help on creating a worksheet. I have it created, my issue was writing code for having one check box selecting multiple check boxes. That sounds like a certain problem to me. Not a do it for me cause I am incompetent question. But thanks for the help .

  4. #4
    Registered User
    Join Date
    01-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: One checkbox that selects multiple checkboxes

    If CheckBox1.Value = True Then

    CheckBox2.Value = True
    CheckBox3.Value = True
    CheckBox4.Value = True

    endif

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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