| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box
Hi All, How can I get a check box to return TRUE, in a cell of my choice Thanks Mike -- Mike ------------------------------------------------------------------------ Mike's Profile: http://www.thecodecage.com/forumz/member.php?userid=236 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90492 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box
There are 2 places to get a check box from.
Bring up the Torms Toolbar - Select a check box and draw it on your sheet - Rigth click the check box and select Format Control - Select the Control tab - Add a cell reference to the Linked Cell Bring up the Control Toolbox - Select a check box and draw it on your sheet - Rigth click the check box and select Properties- Add a cell reference to the Linked Cell - Exit Properties - Exit Design Mode by clicking the Triangle Ruler & Pencil icon on the Control Toolbox. -- HTH... Jim Thomlinson "Mike" wrote: Hi All, How can I get a check box to return TRUE, in a cell of my choice Thanks Mike -- Mike ------------------------------------------------------------------------ Mike's Profile: http://www.thecodecage.com/forumz/member.php?userid=236 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90492 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box
problem solved thanks for your help Mike Jim Thomlinson;323895 Wrote: There are 2 places to get a check box from. Bring up the Torms Toolbar - Select a check box and draw it on your sheet - Rigth click the check box and select Format Control - Select the Control tab - Add a cell reference to the Linked Cell Bring up the Control Toolbox - Select a check box and draw it on your sheet - Rigth click the check box and select Properties- Add a cell reference to the Linked Cell - Exit Properties - Exit Design Mode by clicking the Triangle Ruler & Pencil icon on the Control Toolbox. -- HTH... Jim Thomlinson "Mike" wrote: Hi All, How can I get a check box to return TRUE, in a cell of my choice Thanks Mike -- Mike ------------------------------------------------------------------------ Mike's Profile: 'The Code Cage Forums - View Profile: Mike' (http://www.thecodecage.com/forumz/member.php?userid=236) View this thread: 'Check Box - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=90492) -- Mike ------------------------------------------------------------------------ Mike's Profile: http://www.thecodecage.com/forumz/member.php?userid=236 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90492 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Box
Thanks for the help, mike Jim Thomlinson;323895 Wrote: There are 2 places to get a check box from. Bring up the Torms Toolbar - Select a check box and draw it on your sheet - Rigth click the check box and select Format Control - Select the Control tab - Add a cell reference to the Linked Cell Bring up the Control Toolbox - Select a check box and draw it on your sheet - Rigth click the check box and select Properties- Add a cell reference to the Linked Cell - Exit Properties - Exit Design Mode by clicking the Triangle Ruler & Pencil icon on the Control Toolbox. -- HTH... Jim Thomlinson "Mike" wrote: Hi All, How can I get a check box to return TRUE, in a cell of my choice Thanks Mike -- Mike ------------------------------------------------------------------------ Mike's Profile: 'The Code Cage Forums - View Profile: Mike' (http://www.thecodecage.com/forumz/member.php?userid=236) View this thread: 'Check Box - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=90492) -- Mike ------------------------------------------------------------------------ Mike's Profile: http://www.thecodecage.com/forumz/member.php?userid=236 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90492 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) | |||
![Mike[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
