Hello All

I'd like some help please.

I'm slowly developing an Excel workbook with macro's & userforms & various tables, I've managed to add a new form for users to login to the program, when the excel file is opened, the user is presented with a userform to enter his/her user-id & password, which then, in turn, opens the excel file to the home sheet, data is then only available to enter via another userform to update tables.

Where I need further help is, when the data entry forms open I'd like the current Users ID to automatically show on the userform in a locked textbox (textbox1), so this can then be transferred with the data to the table row being entered, I'm ok with the data transfer-coding, just need some help with the User ID population.

I'd like the User-ID they use to login using the new login form, not the windows or pc id.

Thank you in advance.

Chris