MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

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