Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
get rid of check box in excel spread sheet | Excel Discussion (Misc queries) | |||
How to check if an excel sheet has external references. | Excel Discussion (Misc queries) | |||
How do I use 1 excel sheet to check another? | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
create a housekeeping check sheet on excel | New Users to Excel |