I do not want them to go to the wsheet for a few reasons,
first the list is quite long and it would be a waste of time,
one of the things the userform does is "filter" by user, or by project
etc as each user can see their own tasks.
Also the workbook is going to be shared, and I do not think the
password protection would work (in order to write new tasks, I believe
you have to unprotect it which has issues with shared workbooks).
Any idea if the listbox colors can be changed?
If not I guess I have to create a whole separate userform just for
past due dates, although that kinda defeats the purpose.