| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checkbox in a protected worksheet | Excel Worksheet Functions | |||
| Checkbox to open another worksheet | Excel Discussion (Misc queries) | |||
| checkbox and worksheet | Excel Discussion (Misc queries) | |||
| error accessing a protected worksheet | Excel Worksheet Functions | |||
| Accessing Cells in Separate Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
