If you find yourself juggling a number of tasks with lots of details, my free Excel Task List Manager may be just the ticket. All you need to do is download and unzip the Access database and Excel workbook into the same directory and hit the ALT plus q keys at the same time. The Excel Task List Manager will pop up and you can begin adding your tasks.
Here you will note the Excel To Do Manager is open and is set via the check boxes to show the tasks that were entered for the 7th of February. From here we can:
1. Add a New Task by clicking the Add New To Do button.
2. Change the tasks viewed by clicking additional check boxes or selecting a different date or edit an existing task by clicking the button to the left of it.
The task maintenance form allows you to modify or delete tasks as well as add a new or modify a sub task – all at a click of a button.
The VBA code that is behind the Excel Task Manager is locked but contact me and I will provide the key. I would like to get an understanding of what improvements or modifications users might appreciate.
Raymond Mills, M.B.A., M.S. has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst. His specialty was using Excel to get Big Databases including Teradata, Oracle, Sequel Server and Sybase to give up their secrets.
Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” If you have a challenge with Excel, Access or Word and would like to speak with Ray, you can get his contact details by clicking here: Contact Me