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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com