ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check Box (https://www.excelbanter.com/excel-discussion-misc-queries/229020-check-box.html)

Mike[_19_]

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


Jim Thomlinson

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



Mike[_20_]

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


Mike[_21_]

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