| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox Code
(I assume that your checkbox is on an UserForm.
Private Sub CheckBox1_Click( If CheckBox1.Value = True Then Activesheet.Range("A2").value = 1 End Su ----- Bob wrote: ---- How do I make this work Private Sub CheckBox1_Click( With CheckBox If .Selected = True The "A2" = 1 End I End Wit End Su Thank you for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| Code question for clearing a command checkbox. | Excel Discussion (Misc queries) | |||
| Simple Checkbox Message Code | Excel Discussion (Misc queries) | |||
| CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
| testing the state of a checkbox in vba code | Excel Programming | |||
![Edwin Tam[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
