Checkbox Userform Question

Hello,

I've created a userform with 4 checkboxes on it.

When a user checks a box, I want it to select a specific column.

So if the user does not want a specific column of data, they will leave the box blank.

I then want a submit button that will take all the selected columns, copy them, and then paste them into a new workbook

Any help with this would be appreciated!

Thanks

I got the form to work using this code:

Private Sub CheckBox9_Click()
If CheckBox9.Value = True Then
Range("k2:k10000").Select
End If
If CheckBox9.Value = False Then
Range("A1").Select
End If
End Sub

but when i click on another checkbox, the selection dissappears and the next checkbox is selected. Is there a way to continue the selection when i click multiple checkboxes?

Thanks!

I know I can manually put in all the data like this:

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Range("b2:b10000").Select
End If
If CheckBox1.Value = False Then
Range("A1").Select
End If
If chkproduct.Value = True Then
Range("a2:b10000").Select
End If
If chkproduct.Value = False Then
Range("b2:b10000").Select
End If
If CheckBox2.Value = True Then
Range("a2:c10000").Select
End If
End Sub

I have a total of 13 columns, making this manual tedious way not an option...