I have written the following code.

Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then
Range("C12:D17").Copy
Range("C18:D23").PasteSpecial
ElseIf CheckBox2.Value = True Then
Range("C12:D17") = "2"
End If

If CheckBox1.Value = True And CheckBox2.Value = True Then
Range("C12:D17") = "3"
End If



End Sub

How can I change it so the copied data is from another Workbook called "VCCS" with a Worksheet called "Main Components"?

Thanks