| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Check Boxes an a worksheet
Hi TWIMC,
can someone please tell me why the following line of code doesn't return the most logical value when a check box is unchecked, ActiveSheet.CheckBoxes("Check Box 1").Value Instead of retunring the expected value 0 it returns -4146. If I set a Linked cell then I do get FALSE and TRUE appearing but I want to reference the value of the Check Box not the cell. I want to reference the value of the check box for the following line of code. ActiveSheet.Columns("D:H").Hidden = ActiveSheet.CheckBoxes("Check Box 1").Value, it works to hide but does't to unhide. Thanks in advance KM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA for form check boxes | Excel Worksheet Functions | |||
| copy check boxes (made from form toolbar) | Excel Discussion (Misc queries) | |||
| VBA code for the Check Boxes in a form | Excel Discussion (Misc queries) | |||
| How do I create a Form with check boxes in Excel | Excel Worksheet Functions | |||
| Can I Group Form Check Boxes? | Excel Programming | |||
Threaded Mode
