Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.14 KB | None | 0 0
  1. Private Sub CommandButton1_Click()
  2.  
  3. TextBox2.Value = Application.VLookup(Me.ListBox1.Text,Sheets("Sheet1").Range("B.C"), 2, False)
  4.  
  5. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement