title: "Unable to get the VLookup property of the WorksheetFunction Class" error
body: <p>I am trying to develop a form to track invoices as they come in. The form will have a combobox where I can click on and select a vendor number. I want the textbox to automatically fill in based on the vendor number selected from the combobox.  Here's what I have so far:</p>
  
  <pre><code>Private Sub ComboBox1_Change()    
      'Vlookup when ComboBox1 is filled
      Me.TextBox1.Value = Application.WorksheetFunction.VLookup( _
          Me.ComboBox1.Value, Worksheets("Sheet3").Range("Names"), 2, False)    
  End Sub
  </code></pre>
  
  <p>Worksheet 3 is from which the information is being drawn (the vendor number and name).  </p>
  
  <p>When I go back to the form to test the code, I get the following error:</p>
  
  <blockquote>
    <p>Run-time error '1004': Unable to get the VLookup property of the WorksheetFunction class</p>
  </blockquote>
  
  <p>How do I fix this?</p>