Hi to all
I have a problem. I have a big sheet with Text in it.
The Text is in Cell D3 and I3 and in K3 is a Active X checkbox.
Sheet 1
A D I K
1 Bla Text Text Checkbox_1
2 Bls Text Text Checkbox_2
Sheet 2
A
1 Full
2 Free here copy D1 and I1
I would like to check the box then copy the text to Sheet2 in the next free cell.
And if i uncheck the text must be delete.
There are about 30 Checkboxes. Then it isent a good solution with Code for every box.
Checkbox_1, Checkbox_2 etc..
Is it posible this to programm? With For next or ???
i have no plans what is to do?
Can anyone help me plz
Greetz Patrick
Bookmarks