Hello All,

I have an excel sheet, where i have set many command button and some textboxes. At the beginning i like to run with a login commandbutton, by clicking the login buttion i have set the password, as soons as the passowrd is validated it should close the userform and open back the worksheet.In work sheet i required the person name and the date & time should be captured. I have created text boxes for the user name and the date&time in excel sheet.

Here i would like to know that, how the capture can be done when we enter the passowrd in userform to excel sheet, when the userform is closed.

Thanks in advance.
Regards,
Kit