OK remember that you know everything about your file and I know nothing. You are going to have to explain more about whag you are doing.
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.
I am not clear on how you are designing the user interaction for entering a date. ScDate is a textbox so you type in whatever text you want. You should not need to format the data in the userform. Also, when you do this in your code
ScDate = Format(ScDate, "dd/mm/yyyy")
the code won't recognize it as a date. This code doesn't actually do anything, unless you type in a data number (enter 44410 then hit Enter and you will see what I mean).
correctly labelling the "sample" shape to the correct taskID
No idea what you are talking about here. You'll have to walk me through it.
Bookmarks