Checkbox values from a web client

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I'd like to pull in checkbox boolean values from some
ActiveX control type checkboxes in Excel to a web client
for user review.

I seem able to pull in a reference to the checkbox object,
but from there I still can't access the value property
directly (object does not support property or method
error). chkBox1.Value works just fine on VBE of course,
but I'm hosed using the same thing in VB script from the
web.

I have no problem pulling in Range.Value for an ordinary
cell, but a named range doesn't seem to work for these
controls (non-specific error, no return value). I'm about
ready to write little handlers to send the value to
regular cells with a named range, and use a white font or
something to make them invisible. Bit new to this, sorry,
but - any ideas?

Thanks much,

Larry
 
xlApp.ActiveSheet.OleObjects("chkbox1").Object.Value

where xlApp represents your variable with a reference to the Excel
Application Instance.

might be part of what you need.
 
Back
Top