+ Reply to Thread
Results 1 to 5 of 5

correct code for and select for some check box and deselect for other

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    correct code for and select for some check box and deselect for other

    Hi all
    i would like to correct the following code
    HTML Code: 
    to do the following function:
    i have OptionButton14 when i select i need to check the checkobox 111, 109,103,102,113,110,104,106,112,108 and deselect for
    155,144,157,154,150,156,149,151,158,159

  2. #2
    Forum Moderator - RIP 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
    29,464

    Re: correct code for and select for some check box and deselect for other

    Apart from the fact that not all the checkboxes you want to deselect are catered for in your procedure (144) and 152 in the procedure is not one you identify, the code would appear to do what you want.

    What do you mean by 'correct'?
    Richard Buttrey

    RIP - d. 06/10/2022

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

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: correct code for and select for some check box and deselect for other

    Correct I mean when i select this OptionButton14 it will select check box 111, 109,103,102,113,110,104,106,112,108 and make 155,144,157,154,150,156,149,151,158,159 unchecked

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: correct code for and select for some check box and deselect for other

    This change every CheckBox, by click Option Button

    just change the true to false or false to true where needed

    Please Login or Register  to view this content.
    Kind regards
    Leo

  5. #5
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: correct code for and select for some check box and deselect for other

    working good

+ 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] correct code to select some check box
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2017, 05:32 AM
  2. [SOLVED] Select/deselect particular (but not all) check boxes using a "select all" box
    By Tayles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2016, 08:32 AM
  3. Help with VBA Code to select and deselect Rw Lable from Powr Pivot Field List
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2016, 08:00 AM
  4. [SOLVED] Code does not select correct data set..
    By Dariusd7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2013, 10:52 AM
  5. [SOLVED] vba code to be correct and check ,vba code to brig data for the same refreince
    By funtastic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2012, 02:29 PM
  6. code to check if user opened correct file
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2010, 12:15 AM
  7. Select / deselect pivot table fields with check box
    By fynn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2008, 08:12 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