+ Reply to Thread
Results 1 to 7 of 7

Is there a way to add a button that selects the next checkbox in a row?

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Is there a way to add a button that selects the next checkbox in a row?

    I have a very large spreadsheet that records pupils levels.
    As they pass each level, the teacher can check off which one they have just completed and the levels pop up next to their name.
    Because this system will be used throughout the school, there are 125 different levels for every child.

    I have checkboxes set up, but I was wondering if there was a way to create a button so that when you press it, it will check off the next consecutive checkbox, instead of having to hunt through all the levels to check off the next one.

    So it would begin with checkbox1, and then if you pressed the button it would check checkbox2, then checkbox3 and so on.

    My macro skills are not brilliant and I'm not sure if this is possible. Any help or suggestions would be greatly appreciated

    Thanks

  2. #2
    Forum Contributor
    Join Date
    06-07-2008
    Posts
    126

    Re: Is there a way to add a button that selects the next checkbox in a row?

    Need to see the file as there are different types of checkboxes and I want to know which type you're using

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: Is there a way to add a button that selects the next checkbox in a row?

    Not the activeX checkboxes, I switched back to the other ones. Ive attached the page with the few thousand checkboxes!
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    06-07-2008
    Posts
    126

    Re: Is there a way to add a button that selects the next checkbox in a row?

    I looked at your file but with over 3500 check boxes that are not sequentially labeled a macro for this job can take quite a bit of time to create and test. So I am sorry I cannot do this work within the context of this free forum

  5. #5
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: Is there a way to add a button that selects the next checkbox in a row?

    I wasn't expecting you to, that would have been a big ask! But in the context of say 5 boxes is it possible? I have no idea where to start but with a base I'm pretty quick at catching on. Any advice on how to start testing something, any help on getting a start going would be much appreciated, I can fiddle my end as much as I need.

    Thanks for looking

  6. #6
    Forum Contributor
    Join Date
    06-07-2008
    Posts
    126

    Re: Is there a way to add a button that selects the next checkbox in a row?

    Here is how it works. First you need to find the smallest and largest checkbox numbers. Then you need to iterate between these two values checking if the box is checked or not, leaving out the numbers that do not have checkboxes assigned to them (by creating an error trapping routine). When the last checked checkbox is found, you change the status of the next box to checked.
    As you can see it is a big deal. You can contact me if you want one on one help with this

  7. #7
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: Is there a way to add a button that selects the next checkbox in a row?

    Thanks for the help, I managed to do it with a very long code! But it's done and 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. Checkbox radial button - very new here
    By tnursall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 01:27 AM
  2. One checkbox that selects multiple checkboxes
    By pozmoney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2013, 05:57 PM
  3. Button to know what checkbox are marked
    By cyberuser in forum Excel General
    Replies: 1
    Last Post: 08-26-2012, 02:42 AM
  4. Code selects entire rows upto one range and same code selects only columns for other.
    By sriharigk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 05:19 AM
  5. CheckBox and Submit Button
    By jenniferkognan in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 06-16-2008, 12:05 PM

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