Templates

Automated Daily Task Manager with auto Check boxes

Daily Task Manager

Daily Task Manager Template is a very useful template to manage your daily tasks. We have used VBA automation to create an auto checkbox when the new task will be entered. We have used conditional formatting to show the completed task and overdue task. The status check box will be deleted automatically when you will delete a task

Fully Functional To-do List in Excel

Task Management System V1.0

Daily Task Manager

To create and delete a check box automatically, we have used below given VBA Code on the worksheet change event-

Private Sub Worksheet_Change(ByVal Target As Range)

Dim check_box
Dim rng As Range
Dim chk_rng As Range


Dim sp As Shape

For Each rng In Target
Set chk_rng = Cells(rng.Row, 4)
If rng.Column = 2 And rng.Row > 2 Then
If rng.Value <> "" Then
If chk_rng.Value = "" Then
Set check_box = Sheet2.CheckBoxes.Add(chk_rng.Left + 10, chk_rng.Top - 2, 40, 20)
check_box.LinkedCell = chk_rng.Address
check_box.Characters.Text = ""
chk_rng.Value = "False"
chk_rng.NumberFormat = ";;;"
End If
End If

If rng.Value = "" Then
For Each sp In ActiveSheet.Shapes
If sp.TopLeftCell.Offset(1, 0).Address = chk_rng.Address Then
sp.Delete
chk_rng.Value = ""
End If
Next
End If

End If
Next

End Sub

Watch the step by step video tutorial:

Click here to download the practice file.

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com