View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucas Reece Lucas Reece is offline
external usenet poster
 
Posts: 18
Default Using VLookup on user form (VBA)

In my workbook I have an "Employees" sheet. Column A is headed
'Payroll Number' and column B is 'Employee Name'.

I then have a combobox in a userform which takes the Payroll Number
from the Employees sheet. To the side of this combo box I have a text
box to store the employee name. When I select a payroll number I need
the employee name to be automatically populated in the employee name
text box using a vlookup(?) from the "Employees" sheet.

My VB skills are limited so looking for a solution if anyone can help
please.

Many thanks.