Oh thank you (again)! This is great and works perfectly. I'm so impressed
1 questions though, my listbox is generated under userform_initialise, when I click sumbit or even close and reopen the userform, it hasn't updated the daily list (presumably because the userform is just hiding and showing not re-initialising), is there a way I can get a 'refresh' button or assign to the open userform button to do the same?
I.E. Company A is on daily call list for today, I call them and they ask for a callback in 2 weeks. When I submit, and maybe close and reopen the form, they are still in the call list until I save-close-reopen the workbook.