Retrieving the state of a checkbox (form type) from VB .NET?

[Guest]

Hi,

I'm hoping someone here has the saavy to solve this problem. I can't figure
out how to get the state of a checkbox (the Form-type) from VB.NET.

I can get the state of the Control Toolbox version just fine.

Here's my code for the control-type checkbox

Dim testOLE As Excel.OLEObject
testOLE = oWorkSheet.OLEObjects("CheckBox1")

However, this won't work with the Form-type, so I'm assuming the Form-type
is an OLEObject, but I no idea what it could be (a shape object?).

Anyone have any ideas what its handle might be? And yes, I have to use the
form-type. Help would be appreciated

 

[Dave Peterson]

I don't use vb.net, but if I were doing it in excel, I'd do:

dim testCBX as excel.checkbox
set testcbx = oworksheet.checkboxes("check box 1")

(checkboxes from the Forms toolbar usually have slightly different spellings
(extra spaces). So be a little careful.)

 

[Guest]

Hmm thanks for the help, but the code didn't work for me.

checkbox didn't seem to be a member of excel.

After tons of searching, i've found out that apparently the Form-type
checkboxes are based on XLM, while the Control-type checkboxes are ADO. XLM
was phased out, but I think there may still be a way to access them with the
Excel 5.0 library.

Anyone have any ideas?

 

[Dave Peterson]

It did work ok for me in excel's VBA.

How about going through the shapes collection.

This also worked for me in excel's VBA:

Dim myShape As Excel.Shape
Set myShape = ActiveSheet.Shapes("check box 1")
MsgBox myShape.OLEFormat.Object.Value
'or
MsgBox myShape.ControlFormat.Value

No guess if it'll work in .Net.