View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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!