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
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