Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set/get value of checkbox (controltoolbox)
Trying to get/set value from a checkbox.
I'm using the controltoolbox-checkbox. I'm using: Worksheets("refdata").Shapes(varname).ControlForma t.Value = 1 but getting a object does not support property error. I need to refer to the checkbox with "varname" being af changable variable. What is the correct syntax? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set/get value of checkbox (controltoolbox)
I'd use something like:
Option Explicit Sub testme() Dim CBX As OLEObject Set CBX = Worksheets("sheet1").OLEObjects("checkbox1") CBX.Object.Value = True End Sub On 04/18/2012 06:21, Jesper F wrote: Trying to get/set value from a checkbox. I'm using the controltoolbox-checkbox. I'm using: Worksheets("refdata").Shapes(varname).ControlForma t.Value = 1 but getting a object does not support property error. I need to refer to the checkbox with "varname" being af changable variable. What is the correct syntax? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OptionButtons from ControlToolbox | Excel Programming | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming |