Login form not reacting to code

@torachan - Hope you're well. I disappear for a short while to cook and eat dinner and when I get back you've pipped me to the post!

@Steve5914 - For what it's worth, my version is attached. I've tinkered around a bit with the code and some of it takes a slightly different approach to torachan's version, but I think does the same job.
I swapped TextBox10 on UserForm1 out for a ListBox as an alternative approach to it. You'll see that historic login date/times look a tad odd, but the format your code would stamp them to Sheet3 will mean they show up in the expected format.

I've also added a couple of little alternatives to a few sections of your code. Feel free to ignore them, obviously, but they may be of interest, so I've added them in but commented them out so they don't affect anything.

BSB

Thank you both for your help but as badley has also amended some other code for me i will stay with it and with him but i tried your demo and its doing what i want but now i have put your code back into my original file its not working how are you referencing what was textbox 10 in your demo list box1 as i have now removed textbox 10 and put a list box there which as i already have a list box in named listbox 2