Help with checkboxes

[hhpack3]

I have attached an excel file that I would like some help on. Im very new to VBA so any help that I can get with this is greatly appreciated. What I need is that the first three check boxes, when they become checked, add the time to the cell to the right of them. I currently have that but it is hard coded to one cell. When the 4th checkbox becomes checked I need it to add the time to the cell to the right, Hide the current row that it is in, and create a new row beneath it with the same check boxes. Is this to much? Thanks in advanced!

[xladept]

Hi hhpack3,

Here's a system to try - copy paste the entire code to your Make up part list sheet:

Please Login or Register  to view this content.

[hhpack3]

That is Awesome and it works Perfectly! Thank You!

[xladept]

You're welcome and thanks for the rep!

[hhpack3]

My needs have changed a little bit, do you think you could help one more time?

[xladept]

Yes, I can help again - later

[hhpack3]

So it gets a little more complicated. I need checkbox one to create a new row that has the check boxes in it, and check box four to close the row. Does that make sense?

[xladept]

By "close the row" do you mean hide and move check the boxes as it does now?

It seems that you want box#1 to do as box#4 does now.

I think I need more clarification.

[hhpack3]

By close I do mean hide, and essentially I want CB1 to create a new row with the check boxes in the same place, but have the CB's in the current row stay also. Im not even sure that is possible.

[xladept]

We'd have to create another set of checkboxes- naming them would become an issue!

[hhpack3]

Could they keep the same name? That in my head seems like it would work. So in the row underneath checkbox 1 would be checkbox 1 again and so on.

[xladept]

That's impossible

[hhpack3]

Okay ive got another idea then, how about when you check the 1st check box it puts the time to the right, and creates a new row. 2 and 3 stay the same, and 4 hides the current row.
And all the times go to the next available row in the column instead of just the one directly to the right. Does this sound like itll work?

[xladept]

When do we move the checkboxes? Or, do you want to just leave them on top??

[hhpack3]

After the 4th box is checked please.

[xladept]

Try this - let me know of issuesCBMover2.xlsm

[hhpack3]

Its almost perfect! I hate to be nit picky but is there code that can make the check boxes can uncheck them selves? I should have specified that, other than that it works awesome!

[xladept]

Well

Please Login or Register  to view this content.

replace CB.Name with "CheckBox1" etc

[hhpack3]

Thank you very much. I could have never done that! I think its perfect now!

[xladept]

You're welcome!