accessing CheckBox on Worksheet
create a command button
go into design mode
double click on the command button
paste this code:
Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then
CheckBox1.Value = False
Else
CheckBox1.Value = True
End If
End Sub
exit design mode
click the command button
"German" <german.koninin@crm-worldwideDOTnet wrote in message
...
Hi.
I have a checkbox on one of the worksheets.
How can I access this checkbox programmatically in Excel?
Thanks a lot. I'm going to be crazy with this task.
|