CheckBox

[keithfender]

I've just added the Forms and Control Toolbox toolbars in Excel, but I'm not sure which item I need to do what I want.

I have what I'm calling an Action List, with different projects I need to work on and their due dates. I would like to add a completion check box or something similar so that when I click it for each row of the action list, it will format that row to have a black background or strikethrough font.

Is something like this possible. I can't seem to figure it out on my own just by playing with it.

Thanks in advance,

-Keith

EDIT: Dummy File Attached

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[keithfender]

OK, thanks for the tip, royUK. I have attached the dummy file. I guess I want the check box to do something like conditional formatting, and for each row.

-Keith

[keithfender]

My Action List is due on Wednesday. This would be an impressive feature to add. Thanks again for the help. Bump.

[Huron]

I've put 2 methods in your file. The first sheet CF is just using conditional formatting to strike through the text if you type "1" in the Check Box column. The second sheet VBA has proper check boxes and uses code to change the formatting if the boxes are checked.

[Palmetto]

I would opt for using a Marlett check box instead of a checkbox control. It presents a more professional appearance ( IMO ) by removing the clutter of a lot of checkbox controls.

Building on Huron's idea . . .
The attached uses the below code in the worksheet_selectionchange event to place a checkmark into the cell when the cell is selected. Selecting a cell with the checkmark will remove it as well as the strikethrough formatting.

Please Login or Register  to view this content.