Excel Macro Tiny Task Manager: Build a Simple List

VBA & macros · Updated November 22, 2026

If you mean a tiny task manager built with an Excel macro, yes: a short VBA macro can create a basic task list, add tasks, and mark a selected task complete. It is a small workbook-based organizer, not Windows Task Manager; the similarly named TinyTask is a macro recorder, not a task-management app.

What an Excel macro task manager does

In Excel, a macro is a set of instructions that automates actions. A simple task-manager macro can turn a worksheet into a lightweight list with a task name, the time it was added, its status, and a completion date. You can then run a macro to add a task or mark the selected task as done. The worksheet remains the place where the information is stored and viewed.

This kind of tool is useful when the goal is modest: keeping a short personal checklist in a workbook you already use, automating a repetitive entry, or learning how VBA connects a button or command to spreadsheet data. It does not provide the broader features of a dedicated planner, such as notifications, shared assignments, mobile synchronization, or project dependencies.

The phrase “tiny task manager” can also mean a very small computer utility. Windows Task Manager monitors running apps, processes, and system performance; it does not organize personal to-do items. TinyTask, a separate Windows program, records and replays mouse and keyboard actions. It can repeat a workflow, but recording keystrokes is not the same as maintaining a task list.

What this example includes

The VBA example below makes a worksheet named Tasks and provides two actions: add a task and mark the selected task complete. Its four columns are Task, Created, Status, and Completed. New items start with the status Open; completing an item changes the status to Done and records the completion date.

  • Task: a short description, such as “Send the revised agenda.”
  • Created: the date and time the item was added.
  • Status: Open or Done.
  • Completed: a date entered when you mark an item done.

This intentionally avoids due-date parsing, recurring tasks, reminders, priorities, and multiple users. Those features require more design and testing. For a small list, the simpler structure makes it easier to inspect and edit the data directly in the worksheet if necessary.

Set up the workbook and add the VBA

Use desktop Excel for Microsoft 365 on Windows. Start with a new, blank workbook, then save it as an Excel Macro-Enabled Workbook (.xlsm). On Windows, open the Visual Basic Editor with Alt+F11, choose Insert > Module, and paste the complete code below into the module. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon.

On Excel for Mac, VBA is available in the desktop app, but menu names and keyboard shortcuts can differ; open the Visual Basic Editor from Tools > Macro > Visual Basic Editor. Excel for the web can display and edit a macro-enabled workbook, but it cannot create or run VBA macros. The setup routine creates a Tasks worksheet if one does not exist. If a worksheet named Tasks already contains unrelated data, the routine stops rather than replacing that content.

Option Explicit

Private Function GetTaskSheet() As Worksheet
    On Error Resume Next
    Set GetTaskSheet = ThisWorkbook.Worksheets("Tasks")
    On Error GoTo 0
End Function

Public Sub SetupTinyTaskManager()
    Dim ws As Worksheet

    Set ws = GetTaskSheet()
    If ws Is Nothing Then
        Set ws = ThisWorkbook.Worksheets.Add( _
            After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count))
        ws.Name = "Tasks"
    End If

    If Application.CountA(ws.Cells) > 0 Then
        If ws.Range("A1").Value = "Task" And _
           ws.Range("B1").Value = "Created" And _
           ws.Range("C1").Value = "Status" And _
           ws.Range("D1").Value = "Completed" Then
            MsgBox "The task list is already set up."
        Else
            MsgBox "The Tasks sheet contains data. No changes were made."
        End If
        Exit Sub
    End If

    ws.Range("A1:D1").Value = Array("Task", "Created", "Status", "Completed")
    ws.Range("A1:D1").Font.Bold = True
    ws.Columns("A").ColumnWidth = 42
    ws.Columns("B").ColumnWidth = 20
    ws.Columns("C").ColumnWidth = 14
    ws.Columns("D").ColumnWidth = 14
    ws.Columns("B").NumberFormat = "yyyy-mm-dd hh:mm"
    ws.Columns("D").NumberFormat = "yyyy-mm-dd"
    ws.Range("A1:D1").AutoFilter

    MsgBox "The task list is ready."
End Sub

Public Sub AddTask()
    Dim ws As Worksheet
    Dim answer As Variant
    Dim taskText As String
    Dim nextRow As Long

    Set ws = GetTaskSheet()
    If ws Is Nothing Then
        MsgBox "Run SetupTinyTaskManager first."
        Exit Sub
    End If

    answer = Application.InputBox( _
        Prompt:="Enter a task description:", _
        Title:="Add a task", Type:=2)
    If VarType(answer) = vbBoolean Then Exit Sub

    taskText = Trim$(CStr(answer))
    If Len(taskText) = 0 Then Exit Sub

    nextRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row + 1
    ws.Cells(nextRow, "A").Value = taskText
    ws.Cells(nextRow, "B").Value = Now
    ws.Cells(nextRow, "C").Value = "Open"
End Sub

Public Sub CompleteSelectedTask()
    Dim ws As Worksheet
    Dim selectedRow As Long

    Set ws = GetTaskSheet()
    If ws Is Nothing Then
        MsgBox "Run SetupTinyTaskManager first."
        Exit Sub
    End If
    If Not ActiveSheet Is ws Then
        MsgBox "Select a task on the Tasks sheet first."
        Exit Sub
    End If

    selectedRow = ActiveCell.Row
    If selectedRow < 2 Or Len(ws.Cells(selectedRow, "A").Value) = 0 Then
        MsgBox "Select a task row, not the header or an empty row."
        Exit Sub
    End If
    If ws.Cells(selectedRow, "C").Value = "Done" Then
        MsgBox "That task is already marked Done."
        Exit Sub
    End If

    ws.Cells(selectedRow, "C").Value = "Done"
    ws.Cells(selectedRow, "D").Value = Date
End Sub

The HTML entities shown for less-than signs in the code block represent the literal VBA characters: when pasting, use < as the VBA operator <, not the five-character text “&lt;”. In a normal HTML rendering, entities display as their corresponding character, so copy the displayed code rather than the entity spelling if your editor offers a copy button.

Run the macros and use the list

Run SetupTinyTaskManager once to initialize the sheet. In Windows Excel, press Alt+F8, select a macro, and choose Run. The AddTask macro asks for a description; the CompleteSelectedTask macro acts on the row containing the active cell. You can also place buttons on the sheet using Developer > Insert > Button (Form Control), then assign the relevant macro to each button. Menu labels can vary slightly across platforms.

For example, enter “Send the revised agenda” using AddTask. Excel adds it on the next available row with a creation timestamp and Open status. Click any cell in that task’s row and run CompleteSelectedTask; the status becomes Done and the Completed column receives today’s date. Selecting the header, an empty row, or a task on another sheet prompts a message instead of changing a task.

The completion routine records a calendar date, not the exact time. The created value records both date and time. If you need an exact completion time, the macro can be adapted to use Now instead of Date and the column’s number format can show hours and minutes. Consider the format you want before changing code, and keep the underlying values as Excel dates rather than typing decorative date text into the cells.

Limitations and sensible alternatives

This is a local workbook feature, not a full task-management service. It has no automatic reminders, due-date alerts, sync engine, account system, or collaboration workflow. Excel can store and filter the entries, but the macros do not send notifications or prevent two people from editing conflicting copies. If your work depends on assigned owners, recurring schedules, approvals, or reliable phone notifications, a dedicated task app is likely a better fit.

For a short list, the AutoFilter arrow in the header can help show Open or Done items. You can sort or filter the worksheet using Excel’s normal data tools without adding more VBA. Do not sort only one column: select the list or use the filter controls so task names remain paired with their dates and statuses. A formal Excel Table can also make a growing list easier to filter and format, but this starter macro deliberately uses a plain range to keep setup small.

  • Choose a worksheet list for a personal checklist, straightforward filtering, or a simple VBA learning project.
  • Choose a built-in task app when reminders, phone access, or recurring items matter more than spreadsheet customization.
  • Choose a shared project tool when several people need assignments, permissions, activity history, or a shared source of truth.

Common problems and fixes

If Excel says macros are disabled, check the workbook’s file type and security banner. The file must be saved as .xlsm to retain VBA. Only enable macros for a workbook you trust; do not change Excel’s global security settings to allow every macro. On a managed work computer, an administrator may control macro policies.

If the macro is missing from the Alt+F8 list, confirm that the code is in a standard module in this workbook, that the file is macro-enabled, and that the procedure is declared Public. If AddTask reports that setup must run first, run the setup macro or check that the worksheet is named exactly Tasks. If a macro stops at a line in the editor, read the highlighted line and verify that the code was pasted intact.

If a new entry appears far below the other tasks, there may be stray content in column A. The macro finds the next row based on the last nonempty cell in that column, so inspect and remove unintended entries before adding more tasks. If a task was marked done by mistake, edit its Status and Completed cells manually; the simple macro does not include an undo or reopen command.

Safety, privacy, and saving

The example code only reads and writes cells in the workbook, displays prompts, and formats the Tasks sheet. It contains no network requests or file-deletion commands. Still, VBA can perform powerful actions, so review code before running it and avoid enabling macros from unexpected email attachments or downloads. The workbook’s task descriptions may also contain private information; store and share the file according to your normal data-handling practices.

Save a backup copy before experimenting with or modifying VBA. Macro actions generally cannot be reversed with Ctrl+Z, so a mistaken run may require restoring a saved version or correcting cells manually. A macro-enabled workbook can be stored in a trusted location if your organization permits it, but do not treat “trusted” as a reason to run code whose source you do not understand.

Frequently Asked Questions

Is a macro task manager the same as Windows Task Manager?
No. Windows Task Manager shows and manages running programs and system processes. The Excel example organizes personal to-do items in a worksheet; it does not monitor computer performance.

Is TinyTask a task manager?
No. TinyTask is known as a Windows macro recorder that captures and replays user actions. It can automate repeated input, but it is not a checklist or project planner.

Can this Excel macro run in Excel for the web?
No. Excel for the web does not run VBA macros. Use desktop Excel for Windows or Mac to execute the code; web users can still view and edit workbook cells, subject to file and organization settings.

Can I add due dates and reminders?
You can add a due-date column with VBA or directly in the worksheet, but the sample does not implement reminders. A due-date cell alone will not notify you; notifications require additional automation or another tool.

Will the list work for multiple people?
The worksheet can be shared through supported Microsoft 365 storage, but simultaneous edits and macro behavior depend on the sharing setup. This small macro is not designed for multi-user task assignment or conflict management, so use a shared task service when coordinated work is important.

Related

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.