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
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