Check Box???

[Derpeder]

Can you make check boxes, so say I finish a task then I just click a box and it shows I completed it?

let me know

 

[erik.van.geit]

Hello, Derpeder
Welcome to the Board !!!!!

this would need some clarification
do you want to check if a (manual) task has been completed correctly ?
what would be the task ?
perhaps you don't need code ...

kind regards,
Erik

 

[lenze]

Hi and welcome to the board

Don't use a checkbox. They're hard to work with if you have very many. Place this code in the WorkSheet module (Right Click on the Sheet Tab and choose view code)

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 
    If Target.Count > 1 Then Exit Sub 
    If Target.Column <> 1 Then Exit Sub 
    Target.Font.Name = "marlett" 
    If Target.Value = "" Then 
        Target.Value = "a" 
    Else: 
        Target.Value = "" 
    End If 
Cancel = True 
End Sub

This code will toggle any cell in Column A between an "a"(checkmark in marlett font) and blank when a cell is double clicked. You can use the value "a" in IF's and other formulas. Change column number to desired column.

HTH

lenze

 

[Derpeder]

Erik,

Thank you for the welcome. This site should be very helpful for me.

What I'm looking for is to just click a box to show that a task has been done. Yes for the most part it would be manual tasks. Its mainly just a convenience thing. Instead of say typing something in or highlighting. I'd like to be able to click a box to show its been completed.

Thanks.

 

[erik.van.geit]

to be sure: see lenzes reply

are we talking about tasks in Excel ?
you could apply conditional format to check if all cells in a range have been filled in
or
are you talking about a series of tasks like "getting some coffee, call the boss at 10AM, ..." ?

 

[Derpeder]

the second.

Get Coffee - Check
Do this - Check
Do that - Check
Eat lunch -

thats it


Plus how do you change the code in a particular cell?

 

[Derpeder]

Lenze

I figured it out........thank you.

IS there a way I can change the code so it checks in a different column, or multiple columns?

 

[erik.van.geit]

lenzes option would be fine for the task
write your jobs in column B and paste the code in the sheetmodule
http://www.cpearson.com/excel/events.htm
TO INSTALL IN SHEET CODE WINDOW:
1. right click the "Name Tab" of sheet you want code to work in
2. Select "View Code" in drop down menu
3. VBE window will open ... paste code in and exit VBE

only a few minutes to check out

your last question is not clear to me

Plus how do you change the code in a particular cell?

greetings,
Erik

 

[Derpeder]

I figured out what I was asking about the code in a cell. Thanks

 

[erik.van.geit]

IS there a way I can change the code so it checks in a different column, or multiple columns?

read the code ! it's almost plain english

If Target.Column <> 1 Then Exit Sub

edit to suits
example

If Target.Column <> 2 And Target.Column <> 4 Then Exit Sub