+ Reply to Thread
Results 1 to 4 of 4

"tick all"-check box

  1. #1
    Forum Contributor
    Join Date
    03-04-2013
    Location
    Europe
    MS-Off Ver
    Office 365 ProPlus
    Posts
    147

    "tick all"-check box

    I have check boxes, option buttons and other things connected to a (update-via-button) macro. I'd like to create a check box/button that selects all/none of the check boxes in a certain group. My thought was that i link a normal check box to macro which simply ticks or unticks all the check boxes in my group, is it possible to tick/untick a check box from within a macro? Other ideas for solution?

    Very simple example workbook attached.
    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: "tick all"-check box

    If you cell link check boxes 1-6 to range A1:A6 then setting the range A1:A6 to FALSE will uncheck all tickboxes.

    For X = 1 to 6
    Range("A" & X).value = FALSE
    Next x
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    08-23-2010
    Location
    india,Chennai
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: "tick all"-check box

    see attached excel
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-04-2013
    Location
    Europe
    MS-Off Ver
    Office 365 ProPlus
    Posts
    147

    Re: "tick all"-check box

    Thanks mohanvijay, that was exactly what i was looking for!

+ 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