View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
Mike Tomasura Mike Tomasura is offline
external usenet poster
 
Posts: 32
Default 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.