title: Userform VLOOKUP not working
body: <p>I’m trying to extract the employee name based on the employee id with a <code>VLOOKUP</code> formula in a User Form.</p>
  
  <p>The code below inst working. </p>
  
  <pre><code>   Private Sub CommandButton2_Click()        
     Label4.Caption = Sheet1.Application.WorksheetFunction.VLookup(TextBox1.Text, Range("A:B"), 2, False)
     End Sub
  </code></pre>