nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Really hope someone can assist and hope I can explain this well enough.
I have a userform which will record tasks. I add numerous data to each record and then submit the record into the spreadsheet via the userform.
On the userform I have a field (textbox) that will contain a date (due date of the task).
I have a macro that runs through a command button which looks for all tasks which are overdue (due dates which have been passed, less than TODAY).
On the userform I have a listbox which displays my records. I use an advanced filter to do this.
I need to be able to show in the listbox all records that are overdue.
Im hoping someone can assist, it will be a great help, appreciate any help.
Thanks,
I have a userform which will record tasks. I add numerous data to each record and then submit the record into the spreadsheet via the userform.
On the userform I have a field (textbox) that will contain a date (due date of the task).
I have a macro that runs through a command button which looks for all tasks which are overdue (due dates which have been passed, less than TODAY).
On the userform I have a listbox which displays my records. I use an advanced filter to do this.
I need to be able to show in the listbox all records that are overdue.
Im hoping someone can assist, it will be a great help, appreciate any help.
Thanks,