Hi,

Sorry but it's not really clear exactly what you want.

Do you want some code to enter the start and end times when you click some buttons?  That is, the elapsed time between clicks? 

Phil

Hi,Phil

could you share your code like you said?

thanks

I don't clearly understand what you want, you haven't answered my question.

I don't understand how logging in or logging out in Excel is achieved?  What exactly are you trying to do?

I'm not sure if you want a userform or just some dialog boxes asking the user questions.

Can you provide a sample workbook with some screenshots or drawings of what it is you want to do?

Thanks

Phil

Hi Phil

 I want to log in by userform with

username and password,i input right username and pw right it let me log in otherwise log out,how code goes?

hope you see

thanks

Hi,

What are you logging in to?

How do you check that the username and password are correct?  This would need a database or some sort of lookup in a file/list?

You really need to attempt this for yourself and then I can have a look at what you are trying to do.  The requirements are too vague at the moment for me to attempt to write something that I may spend a lot of time doing, but it isn't what you need.

And how does it all relate back to recording the date and time?

Have you read these posts on userforms?  They might help get you started:

https://www.myonlinetraininghub.com/excel-forms

https://www.myonlinetraininghub.com/excel-forms-insert-update-delete

Phil

Hi,Phil

your artcles're  really great

Thank you so much.

no worries 🙂