title: how to use vlookup to populate a listbox on a userform after inputting a number in a combobox on the same userform using excel 2010
body: <p>I am using a userform in excel 2010. I want to input an employee number in ComboBox9 and when I press tab, I want another listbox to show the lastname of who has that employee number. Then I can continue with entering data in the other userform boxes...I am working with this so far but it wont work.</p>
  
  <pre><code>Private Sub TextBox531_Change()
     Dim LName As String
     LName = WorksheetFunction.VLookup(ComboBox9.Value, Worksheets("Tables").Range("Officers"), 2, False)
     TextBox531.Value = LName
  End Sub
  </code></pre>
  
  <p>It returns the error:</p>
  
  <blockquote>
    <p>Error says Unable to get the Vlookup property of the WorksheetFunction
    class</p>
  </blockquote>