Refeencing a check box on an Excel sheet
activesheet.checkboxes("Check Box 95").value
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"jayklmno" wrote in message
...
I have added a check box control to a sheet in Excel and am trying to
check
that box for it's true/false value. How do I find out the name of the
control? I see Excel named it Check Box 95, but I can't get it to refernce
the value...
if checkbox95 = true then...
doesn't work, or when I refernce the sheet directly. What is the correct
syntax for this..
Thanks!
|