| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox
what would the code be to make a checkbox when it is
checked it would put the number 2 into a cell |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
checkbox
try this
Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1") = "2" Else Range("A1") = "" End If End Sub "mark" wrote in message ... what would the code be to make a checkbox when it is checked it would put the number 2 into a cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox | Setting up and Configuration of Excel | |||
| Checkbox | Excel Discussion (Misc queries) | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| checkbox | Excel Worksheet Functions | |||
| checkbox? | Excel Worksheet Functions | |||
Linear Mode
