longyp
06-05-2011, 11:51 PM
you have to first calculate the name of the checkbox.
Hello Everyone
My checkbox is reference via
sheets("Cover Page").checkboxN.value (where N is a number starting at 1..)
Challenge is checkboxN needs to be determined - i.e. it could be Checkbox2, Checkbox3, Checkbox4 etc which I have done.
However
I have constructed a string (I tried variant too) containing the reference and tried passing this to the EVALUATE function but no matter how I construct the string, trim it etc EVALUATE always returns TYPE MISMATCH
Strangley if I type EVALUATE(Sheets("Cover Page").Checkbox1.value) in the immediate window I get a true/false response.
Any ideas? Am I making sense!
Thank you everyone
Hello Everyone
My checkbox is reference via
sheets("Cover Page").checkboxN.value (where N is a number starting at 1..)
Challenge is checkboxN needs to be determined - i.e. it could be Checkbox2, Checkbox3, Checkbox4 etc which I have done.
However
I have constructed a string (I tried variant too) containing the reference and tried passing this to the EVALUATE function but no matter how I construct the string, trim it etc EVALUATE always returns TYPE MISMATCH
Strangley if I type EVALUATE(Sheets("Cover Page").Checkbox1.value) in the immediate window I get a true/false response.
Any ideas? Am I making sense!
Thank you everyone