Hi all,

I can't see what is wrong with my code:

MyRange is a two column table on Sheet1 (an actual XL table). I have it firing as a 'Userform_initialize' event if that matters?

TextBox1.Text = Application.VLookup(ComboBox1.value, Sheets("Sheet1").Range(MyRange), 2, False)