View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moogleii moogleii is offline
external usenet poster
 
Posts: 2
Default Retrieving the state of a checkbox (form type) from VB .NET?

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