Excel VBA - Auto adding checkboxes

[TheGnome]

Ok so what I'm aiming for here is a form, Which has essentially 3 buttons on top.


One of these buttons adds a new Row to the form (the row contains all the elements of the previous row and includes a checkbox automatically in the leftmost cell.

This I have working with the following macro attached to one of the buttons:

Please Login or Register  to view this content.

The part on which I'm stuck is the next button.. Which should hide any row which contains a Check Box that is not currently clicked, and then send the form to the printer. Is there a better way to implement this, and have it be automated as the macro above was?

Please Login or Register  to view this content.

[Leith Ross]

Hello TheGnome,

Welocme to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

3. You can also do this manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the line.


As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules