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"
Target.Value = ""
Cancel = True
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.
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.
are we talking about tasks in Excel ?
you could apply conditional format to check if all cells in a range have been filled in
are you talking about a series of tasks like "getting some coffee, call the boss at 10AM, ..." ?
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?