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 “<”. 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
- Split a String in Excel: Separate Text into Columns
- Accounting Trial Balance Worksheet: How It Works
- Google Sheets SPLIT Function: How to Separate Text
Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.
More in VBA & macros
- Macro Recorder for Mac Excel: Setup, Steps, and LimitsYes. Excel for Microsoft 365 for Mac has a macro recorder: enable the Developer tab if it is…
- VBA Loop Continue: How to Skip to the Next IterationVBA has no built-in Continue For, Continue Do, or general Continue statement. To skip the rest of the…
- Excel VBA Error 9: Subscript Out of RangeExcel VBA run-time error 9, “Subscript out of range,” means your code requested an item that does not…
- Vba loop through rows?Learn how to loop through Excel rows with VBA, find the last row, handle conditions and deletions, and…
- VBA AutoFilter Criteria1: Syntax, Examples & Tips in ExcelIn VBA, Criteria1 is the first filter condition passed to Excel’s AutoFilter method; for example, Criteria1:="East" keeps rows…
- VBA Range Address: Get, Set, and Understand ReferencesIn Excel VBA, use a range’s Address property to return its cell reference as text: for example, Range("B2:D5").Address…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.