Input Box User Selects Data

[basketball2524]

Does anybody know how to create a macro for when a user hits a button it will prompt an input box that the user can select which user they are from a list. Now with every user has an Id number. When the User Selects there name and hits ok then The user name will go to Column K and the User Id will go to Column L. The amount of files will vary so it will need to run in a loop until there is no more data found in Column D.

For Demo purpose we can use the names John Doe, Jane Doe and with the user ID's of 2765, 8976.
test.xlsm

[stnkynts]

It is not clear what the purpose of column D is

[basketball2524]

Column D is basically my check point for the loop that will be needed. If no information is found in Column D then there are no more rows for the User,User Id to be entered. If there is another way to do this that is fine tho.

[stnkynts]

A loop of what? Your test work book only has data in column D. Do you want to loop through each data in column D and select a user / user id for each one?

[basketball2524]

What I'm saying is I expect a loop to have to be put in for this to work. I'll have sheets that there will be 50 rows filled out or 1000 rows filled out. I would need for the user to choose there name from the list on the input box and when they do it updates the columns with their user name and user ID for all the rows found on the sheet with one click of the button. In the sample workbook it only has information in Column D. and the macro I'm trying to get help with is what will fill out the other columns.

[stnkynts]

K. Let me see if I got this right. You want the user to select a User Name from a list, which will have a single accompanying user id. That user name and user id will be inserted into each row (columns K & L respectively) for each row that has data in column D. Is this correct?

[basketball2524]

Yes, I appreciate the help.

[stnkynts]

I did up a UserForm for you. Click the button on your main page.

test (1).xlsm

[basketball2524]

That works perfectly. Just one question where do I go I wanna change the code for the columns or the users?

[basketball2524]

Nevermind I found it. I appreciate the help.

[jaslake]

Hi basketball

Here's another approach