excel consultants - Userform combobox and textbox

Hi,

I'm building a userform in excel and am having difficulty with a couple of textboxes and a combobox.

When the User selects an option from the combobox, I would like the 2 textboxes to update with information from the same range the combobox selections are picked from.

I know I can't use vlookup, so how do I do it?!

Many thanks in advance.