Taking data from 2 different sheets

Posted by Zebadee on September 02, 2001 4:55 AM

I have setup a spreadsheet. I need to pull data from either sheet1 or sheet2 depending on which checkbox has been pressed to calculate the results on my main spreadsheet. Is this possible

In hope
Z

Posted by Tommy on September 02, 2001 4:56 PM

Private Sub CheckBox1_Click()
If CheckBox1 = True Then
'Do your thing here
Else
'Do something else
End If
End Sub