software

I have written the following code.

Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then
Range(quot;C1217quot;).Copy
Range(quot;C1823quot;).PasteSpecial
ElseIf CheckBox2.Value = True Then
Range(quot;C1217quot;) = quot;2quot;
End If

If CheckBox1.Value = True And CheckBox2.Value = True Then
Range(quot;C1217quot;) = quot;3quot;
End If
End Sub

How can I change it so the copied data is from another Workbook called
quot;VCCSquot; with a Worksheet called quot;Main Componentsquot;?

Thanks--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: www.excelforum.com/member.php...oamp;userid=30818
View this thread: www.excelforum.com/showthread...hreadid=506314