ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need to add a check box a group of cells (https://www.excelbanter.com/excel-discussion-misc-queries/133078-need-add-check-box-group-cells.html)

[email protected]

Need to add a check box a group of cells
 
Hello,

I need to add a check box to a group of cells so that when I click on
that cell a check appears in the cell. I have searched here and read
up on the alt 0252 wingdings trick. Unfortunately that is not what I
am looking for. I just want the box...not the check mark. I want
the check mark to appear once I click on the box. I want to do this
for several columns in a workbook. I do not need to link anything to
the box or have any sort of true/false statements to automatically put
a checkmark in the box for me.

Thanks!


Dave Peterson

Need to add a check box a group of cells
 
View|Toolbars|Forms

There's a checkbox icon on that toolbar.

Click on it and then "draw" on the worksheet where you want it to go.

wrote:

Hello,

I need to add a check box to a group of cells so that when I click on
that cell a check appears in the cell. I have searched here and read
up on the alt 0252 wingdings trick. Unfortunately that is not what I
am looking for. I just want the box...not the check mark. I want
the check mark to appear once I click on the box. I want to do this
for several columns in a workbook. I do not need to link anything to
the box or have any sort of true/false statements to automatically put
a checkmark in the box for me.

Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com