Refeencing a check box on an Excel sheet
No, see Jim's response.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"jayklmno" wrote in message
...
That doesn't bomb out with an error, but it also isn't pulling the correct
value. It's pulling a 1. Shouldn't the checkbox value be true or false
whether it's checked or not?
"Bob Phillips" wrote:
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!
|