How to choose a group of checkboxes?

**Silverado83** · 03-18-2013, 03:15 PM

I am currently working on a spreadsheet that consist of about 100 checkboxes. What i am needing is to be able to select the checkbox and it move to a different sheet within the same workbook.
I am currently using this code to move one checkbox.

Please Login or Register  to view this content.

How would i be able to write it where i can put 1-100 in this code? Where i dont have to write this code 100 times.

Any help with this is greatly appreciated.

**protonLeah** · 03-18-2013, 04:25 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

**Silverado83** · 03-18-2013, 04:31 PM

Sorry about that. When I posted earlier it kept timing out so I didn't know if it posted and then could find it.

Thanks

**jaslake** · 03-18-2013, 09:09 PM

Hi Silverado

Love that Song...love the Movie...I'm an old guy...beside the point...

You probably want to research Class Modules for this exercise...here's a couple of links

http://www.bettersolutions.com/excel...A619860332.htm
http://www.vbaexpress.com/forum/arch...hp/t-4806.html
http://www.vbaexpress.com/forum/arch...p/t-16026.html

Having said that...and that being my first advice...here's some code that will allow you to iterate through CheckBoxes. It depends on what type they are...

If control toolbox

Please Login or Register  to view this content.

If forms toolbox

Please Login or Register  to view this content.

If this doesn't work, post your file, one of us will help you.

**jaslake** · 03-18-2013, 09:18 PM

@Silverado

The Forum has become very frustrating to use...hopefully it'll return to it's former self...It's been a while...perhaps...maybe...

**Silverado83** · 03-19-2013, 12:36 PM

New_Visitor.xlsm

jaslake,
Thanks you for all of the info you provided but the code didnt work.
Here is my spreadsheet. Currently i have 200 checkboxes. 1-100 when checked i want Columns A-F to to move to sheet18 (visitor). checkboxes 101-200 moved to sheet2(reoccuring). any help with this would be great.

thanks

**jaslake** · 03-19-2013, 02:45 PM

Hi Silverado

What should happen to the Data in Sheet Attendance Columns A ---> G once the Data's been moved to the appropriate sheet...should it be cleared?

**Silverado83** · 03-19-2013, 03:21 PM

Jaslake

What i was planning on doing is creating a button in sheet1 that when pressed would save then clear the data. What im also needing to do is everytime the sheet is open it will updated to the current date on sheet 1.

**jaslake** · 03-19-2013, 03:57 PM

Hi Silverado

Ah "crap"...I was hoping we could use a Class Module on this exercise...I've grown quite fond of them...ah well...

So I understand... here you're referring to Column A of Sheet Attendance?

everytime the sheet is open it will updated to the current date on sheet 1

As to the process...You'll enter the Sheet Attendance Data in Columns B through G and select a CheckBox as appropriate. After done entering (1 item or 100 items), you'll click a Button, and the Data will be moved from Sheet Attendance to either Sheet Visitor or Sheet Reocurring and Sheet Attendance will be cleared...Correct?

Anything else I should know?

**jaslake** · 03-19-2013, 11:57 PM

Hi Silverado

This Code is in the attached and appears to do as you describe.

Please note that the sheet is protected and there is a Formula in Column A and Column A is locked.

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Silverado83** · 03-20-2013, 08:04 AM

Yes that is correct....I tried your code this morning but kept getting an error message. i will try when i get home.

Thanks again for all of your help.

**Silverado83** · 03-20-2013, 08:29 AM

Jaslake

Your code is now working thanks....One more question. Depending on current date like today (3/20/13) how would i get that same info from columns b though c to go to a tab named that month? Do you have any recommendations of how to learn what each (properties/Methods) mean. Any suggestions would be greatly appreciated. I would really like to be able to write what you just helped me with.

Thanks again.

**jaslake** · 03-20-2013, 10:31 AM

Hi Silverado

Do you mean move to Month in addition to Visitor and Reoccuring or instead of Visitor and Reoccuring?

As for learning materials, you'll find more that you can absorb here
http://www.excelforum.com/excel-prog...materials.html

**Silverado83** · 03-20-2013, 11:18 AM

In addition

Thanks

**jaslake** · 03-20-2013, 11:33 AM

Hi Silverado

Replace the Code in Module 2 with this

Please Login or Register  to view this content.

**Silverado83** · 03-20-2013, 02:07 PM

Thanks, everything worked great!

**Silverado83** · 03-20-2013, 02:40 PM

Thanks everything is working great.

**jaslake** · 03-20-2013, 02:43 PM

You're welcome...glad I could help. Thanks for the Rep.

How to choose a group of checkboxes?

LinkBack

Thread Tools

Rate This Thread

Display

How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Re: How to choose a group of checkboxes?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions