Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create a checkbox?
Hi to everybody.
I m new to Excel so : How can I create step by step a Checkbox , tie it to a cell (R8c7), an when I check it make a red color unlight in an adiacent cell in th same row (r8c8)? Suppose that the cells are R8c7 and r8c8. Thank yo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create a checkbox?
Hi
try the following: - goto 'View - toolbars' and check 'Controls' - add a checkbox (drag it to your sheet) - right-click on the checkbox, choose 'Properties' and define the linked cell (R8C7) - uncheck the 'Design mode' - select cell R8C8 - goto 'Format - Conditional Format' - enter the formula =R8C7 and choose a format for the case the checkbox is checked -- Regards Frank Kabel Frankfurt, Germany Hi to everybody. I m new to Excel so : How can I create step by step a Checkbox , tie it to a cell (R8c7), and when I check it make a red color unlight in an adiacent cell in the same row (r8c8)? Suppose that the cells are R8c7 and r8c8. Thank you --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create a checkbox?
Thank you Frank..
But now I have a new pb..every time I close the rows I grouped, i witch I ve fit the check box, it moves around the sheet.. I would like it to be fixed and stay inside its cell..and disappea everytime I close the grouped rows ... And also I would like to delete the true or false word that appear written in the cell behind the check box... Thank you agai -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Fuctioning Checkbox | Excel Discussion (Misc queries) | |||
How to create primary/secon single click checkbox line autopopulat | Excel Worksheet Functions | |||
How do I create a checkbox in MS Excel? | Excel Discussion (Misc queries) | |||
I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
How can I make a checkbox create a value? | Excel Worksheet Functions |