Splash Screen help

[rb88]

Let me start by saying I'm very new to the whole VB coding world and any input is VERY MUCH appreciated!

Essentially what I made is a user form with a nice little picture, label, 2 buttons, and a text box. I was able to find the small piece of code to get it to open when the workbook opens, but that's where my knowledge ends. Ideally Id like have whom ever is opening the workbook to be required to put their name in the text box which logs it into a hidden sheet with the time and date they accessed it. One command button would be to proceed to worksheet and the other would close the workbook.

[ranman256]

you dont need the close button. Excel comes with one in the top right corner.

but for the login, if you want only specific persons to view the sheet, then you must keep a list of valid users.
This would also be a hidden sheet.
the login button would take the txtUser text and FIND in the user sheet.
if valid, then unhide the working sheet,
else
give error msg.

record a macro to find a name in the user sheet. put this in the ON CLICK event of the login button.

[pjwhitfield]

If, however you're not looking to validate the users (your post merely states log their name and time) then

Please Login or Register  to view this content.

That will enter the Data from the textbox into A1 of Sheet2 and the current Date&Time into A2, Activate Sheet1 and hide the userform. Change the TextBox1, sheetname and ranges to whatever you need.