I have an existing Excel spreadsheet created by a 3rd party that
contains multiple checkboxs created with forms toolbox as a shape
object. I would appear I cannot set the value of the check box so it
gets checked programically. I can call the value of the checkbox using
objshape.controlformat.value to see if it has a value of 1 for checked
or -4146 for unchecked, but not set it.

I have been searching for an answer to this but to date the resolution
has evaded me.
I'm hoping somebody has a solution to this either directly with a
vbscript or calling a vba function embedded in the excel worksheet.

The preferred option is a vbscript checking the boxes directly since I
had additional code running on the spreadsheet but any solution would
be appreciated.

many thanks in advance..