VB code to copy and past a row or set of cells...
 

Hello. I am developing a work sheet currently which is used to track
my work paper progress.

I would like to have it be a little more flexible for the future so
let me describe what i am looking to do.

In column A i have a checkbox.

This check box will indicate whether a row is used or not.

This check box (checkbox1)will also be blank by default.

when this box is checked i would like it to paste infromtion from
cells B100:F100 into that line
(that line in the example below is line 1)

a b c d
e f
1| [ ] | | |
| | |
..
..
..
..
100 | asdf | 100% | asdf |
asdf | asdf |

note: lines b, d, e, f are list boxes....

this is where the code will have to go i think...

Private Sub CheckBox1_Click()
If CheckBox1 = True Then

CODE IN HERE

End If
End Sub



Is it possibly to have a code that could paste those 5 cells from row
100 to row 1?

Thanks!!!!
any and all help is appreciated...i suck at this kinda stuff..
~Andrew