| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set properties of a Check Box
I've used something like this to set the properties of a ToggleButton.
Me.ToggleButton5.Value = False How can I do this same sort of thing with a Check Box, also created from the Control Toolbox? I've tried the similar syntax, but I get an error. Me.CheckBoxName.Value = False 'Invalid use of Me keyword ActiveSheet.Shapes("CheckBoxName").Value = False 'Object doesn't support this property or method What code is necessary to set the properties of a checkbox? Thanks in advance, Paul -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set properties of a Check Box
You can't use Me in the Immediate Window if that is what you were doing.
This works fine in a code procedure though... Me.CheckBox1.Value = True In the Immediate Window, you can refer to the worksheet directly or via the ActiveSheet object... Worksheet("Sheet1").CheckBox1.Value = True or ActiveSheet.CheckBox1.Value = True -- Rick (MVP - Excel) "PCLIVE" wrote in message ... I've used something like this to set the properties of a ToggleButton. Me.ToggleButton5.Value = False How can I do this same sort of thing with a Check Box, also created from the Control Toolbox? I've tried the similar syntax, but I get an error. Me.CheckBoxName.Value = False 'Invalid use of Me keyword ActiveSheet.Shapes("CheckBoxName").Value = False 'Object doesn't support this property or method What code is necessary to set the properties of a checkbox? Thanks in advance, Paul -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set properties of a Check Box
Thanks Rick. I could have sworn that I tried that. I guess I didn't.
Thanks again. -- "Rick Rothstein" wrote in message ... You can't use Me in the Immediate Window if that is what you were doing. This works fine in a code procedure though... Me.CheckBox1.Value = True In the Immediate Window, you can refer to the worksheet directly or via the ActiveSheet object... Worksheet("Sheet1").CheckBox1.Value = True or ActiveSheet.CheckBox1.Value = True -- Rick (MVP - Excel) "PCLIVE" wrote in message ... I've used something like this to set the properties of a ToggleButton. Me.ToggleButton5.Value = False How can I do this same sort of thing with a Check Box, also created from the Control Toolbox? I've tried the similar syntax, but I get an error. Me.CheckBoxName.Value = False 'Invalid use of Me keyword ActiveSheet.Shapes("CheckBoxName").Value = False 'Object doesn't support this property or method What code is necessary to set the properties of a checkbox? Thanks in advance, Paul -- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set properties of a Check Box
Never mind. I think I got it.
ActiveSheet.OLEObjects("CheckBoxName").Object.Valu e = False -- "PCLIVE" wrote in message ... I've used something like this to set the properties of a ToggleButton. Me.ToggleButton5.Value = False How can I do this same sort of thing with a Check Box, also created from the Control Toolbox? I've tried the similar syntax, but I get an error. Me.CheckBoxName.Value = False 'Invalid use of Me keyword ActiveSheet.Shapes("CheckBoxName").Value = False 'Object doesn't support this property or method What code is necessary to set the properties of a checkbox? Thanks in advance, Paul -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop through column(s) to check values, perform action based on check | Excel Programming | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Properties transferring from excel cells to word file properties | Excel Programming | |||
| check properties of 400 Excel files | Excel Discussion (Misc queries) | |||
| Properties Page is blank for check box Control, other controls | Excel Programming | |||
Hybrid Mode
