| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Check box on?
I have a check box which I would like to turn on... or not turn off in some
code that I previously had turning off all check boxes in the sheet. Here is the code. With ActiveSheet ..CheckBoxes = False End With ActiveSheet.CBX_R3 = True ActiveSheet.CBX_R4 = True is it possible I have the checkbox name's wrong? Thanks for your help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn Check box on?
With ActiveSheet
..CheckBoxes = False End With ActiveSheet.CheckBoxes("CBX_R3") = True ActiveSheet.CheckBoxes("CBX_R4") = True "John" wrote: I have a check box which I would like to turn on... or not turn off in some code that I previously had turning off all check boxes in the sheet. Here is the code. With ActiveSheet .CheckBoxes = False End With ActiveSheet.CBX_R3 = True ActiveSheet.CBX_R4 = True is it possible I have the checkbox name's wrong? Thanks for your help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn Check box on?
You can also set/unset the value as follows:
objSheet.CheckBoxes(1).Value = 1 'Checked, 0-unchecked. .... "John" wrote: With ActiveSheet .CheckBoxes = False End With ActiveSheet.CheckBoxes("CBX_R3") = True ActiveSheet.CheckBoxes("CBX_R4") = True "John" wrote: I have a check box which I would like to turn on... or not turn off in some code that I previously had turning off all check boxes in the sheet. Here is the code. With ActiveSheet .CheckBoxes = False End With ActiveSheet.CBX_R3 = True ActiveSheet.CBX_R4 = True is it possible I have the checkbox name's wrong? Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Turn numbers into words to automate check-writing | Excel Discussion (Misc queries) | |||
| Turn numbers into words to automate check-writing | Excel Discussion (Misc queries) | |||
| Code to automatically turn on and turn off Track Changes | Excel Programming | |||
Linear Mode
