![]() |
Check Box
In excel can I have a specific value assigned to a cell when a corresponding
check box is marked. In summary if is click on an ActiveX checkbox I want the number "3" to appear in a cell just to the right of the checkbox. |
Assign a linked cell to that checkbox (I used A1).
Then use that linked cell in a formula: =IF(A1=TRUE,3,"not checked") I like to use a column right near the checkbox--but I'll hide that column to make things prettier. gtcyberaz wrote: In excel can I have a specific value assigned to a cell when a corresponding check box is marked. In summary if is click on an ActiveX checkbox I want the number "3" to appear in a cell just to the right of the checkbox. -- Dave Peterson |
All times are GMT +1. The time now is 04:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com