+ Reply to Thread
Results 1 to 3 of 3

Easy Macro needed to change some, not all, activeX checkbox to False or True

  1. #1
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    269

    Easy Macro needed to change some, not all, activeX checkbox to False or True

    I have several activeX check boxes and I just want a simple macro to switch 5 of them to false, they are called CheckBox9, 10, 11, etc.

    I have searched the web and only find a macro that does it for all checkboxesl, and can't get those to work for my 5 spectific. Tried lots of opptions, can you help?
    Last edited by caliskier; 01-07-2014 at 12:51 PM.

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

    Re: Easy Macro needed to change some, not all, activeX checkbox to False or True

    If it's always the same 5 checkboxes you could change their names to something like AltCheckBox1, AltCheckbox2 etc. Then in your looping code you can look for the keyword "Alt" in the checkbox name to trigger a switch.
    Elegant Simplicity............. Not Always

  3. #3
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    269

    Re: Easy Macro needed to change some, not all, activeX checkbox to False or True

    I just ran a macro to change the cells they are linked to, not what I wanted to do but it works

+ 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] Use checkbox on sheet ('true' or 'false') to decide if run macro
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 09:12 PM
  2. Change default checkbox output true false into text
    By safonso in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 03:31 PM
  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. Macro to change name value from true to false
    By dvb_24 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2011, 08:22 AM
  5. Checkbox: If true all others are false?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2007, 11:57 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