I do take your point about sequencing, which is very
valid.

May I ask, with your "With Activesheet" routine, do you hide the
userform first so that you can still access the userform  data and then
"Unload" after the transfer to the worksheet  is complete?

Your comments re user  & date/time are very valid.