Listbox then vlookup to set text issue

Total Noob

I have a listbox pulling an array of part numbers (column A) to select from.

The issue is when selecting the part number in the listbox I need to Vlook to the corresponding part number (column B) in the cell to the right to be selected.



Original Code

PartNumber = UserForm1.TextBox1.Text


I'm thinking it needs to be this:

PartNumber = UserForm1.ListBox1.Selected = .listbox1.listindex.Range ("B")