Bagharmin
Board Regular
- Joined
- Nov 22, 2010
- Messages
- 168
Sorry about the vague title.
I have a workbook that will (once completed) be shared between many users. I've created a userform where each person selects their name from a list and enters their password (saved on a hidden worksheet) in order to use the workbook. Once in, the main thing the users will be doing is entering data on another userform. Simple enough so far.
My problem (or at least I think it's going to be a problem) is that, when a user pulls up the userform to enter their data, I want a certain textbox on that form to be populated with that user's name. When signing in, I was taking the user's name and putting it in a cell. Then, when they pulled up the userform I was populating the text box with the contents of that cell. However, from my very limited understanding of shared workbooks, when another user signs in, the cell with the first user's name would then have the new user's name. And even though the first user might still be using the workbook, anytime the userform is activated it would show the 2nd user's name.
What can I do to make sure that the name of the user who activates the userform is the one whose name shows in the textbox?
Would it be better to have them re-sign-in (so to speak) when pulling up the userform so it would know whose name to use? I don't really want to put a bunch of extra hoops in front of them.
I have a workbook that will (once completed) be shared between many users. I've created a userform where each person selects their name from a list and enters their password (saved on a hidden worksheet) in order to use the workbook. Once in, the main thing the users will be doing is entering data on another userform. Simple enough so far.
My problem (or at least I think it's going to be a problem) is that, when a user pulls up the userform to enter their data, I want a certain textbox on that form to be populated with that user's name. When signing in, I was taking the user's name and putting it in a cell. Then, when they pulled up the userform I was populating the text box with the contents of that cell. However, from my very limited understanding of shared workbooks, when another user signs in, the cell with the first user's name would then have the new user's name. And even though the first user might still be using the workbook, anytime the userform is activated it would show the 2nd user's name.
What can I do to make sure that the name of the user who activates the userform is the one whose name shows in the textbox?
Would it be better to have them re-sign-in (so to speak) when pulling up the userform so it would know whose name to use? I don't really want to put a bunch of extra hoops in front of them.
