I've got a userform for input of data. I've got a combobox that picks up employee names from sheet1 A1:A20. but as i need they're payroll number which is in B1:B20. how to i get the combobox to link the employee name in A1:A20 to his employee number in B1:B20 and add that number to a textbox on the userform ?
Use the Combobox ListIndex. remember it starts at 0, so you need to add1, 2 if you have a header row
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
How can I do this from Sheet1 to Sheet2?
Sheet1 Data:
EmployeeName ID
joe 22
Sheet2 Data:
select the employee name from the combo box and it will display the ID in the textbox.
bhangra,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks