How to improve this code to add drop down selection to input box

[Roco]

I would like to improve on the code below. What I would like to do is when the input box asks for "User Name" I would like to have a drop down selection with names to chose from. aka "Roco, Dan, Frank, etc". Any help on this would be greatly appreciated.

Please Login or Register  to view this content.

[:) Sixthsense :)]

You have to use a combobox on a userform and call that userform instead of inputbox

[Roco]

Please Login or Register  to view this content.

[bakerman2]

You need to design a userform with a Combobox in it filled with the required names.
You can add those names with the AddItem-method or use the List-method if the names are listed on a worksheet.

[Roco]

Thank you for your reply.

I just finished the design on the userform with a combobox. The list of names in the combobox are listed on "sheet2!A1:A8" which shows up in the box for selection. I'm having trouble getting the code written to open the userform and placing the name where it needs to go. Also my "OK" and "Cancel" buttons don't seem to be working. Please help.

[bakerman2]

If possible post example file and exact requirements where values are to be placed.
To open the userform you can use the next code

Please Login or Register  to view this content.

which will popup the userform on activating the worksheet.