Thank you Jeff!
It now works. I'm glad I can get help here!!
I have 2 more questions related to this spreadsheet.
The easier one is how do I format the Date in the userform to UK? I tried Cdate and it looked good in the form, but still US form.
The 2nd question related to correctly labelling the "sample" shape to the correct taskID. I this this is why an error code is coming up that shows it is out of range.
Bookmarks