Userform List Box Data On Text Box

Hi!

I have a list box on my Userform that has employee ids.

All I want is when I select an employee id from the list, it should display the corresponding name of the Employee in a text box next to the List Box.

Currently its working, But I have to manually click on the Text Box for that name to display.

I have attached the sample file with Random names for reference & code.

Thank You,

Deep Dave

Add the name to column 2 of the combobox. Retrieve it from the Change event of the combobox.

Please Login or Register  to view this content.

Hi!

Thank you for the help..

Deep