I am a rank beginner...

I have created a userform where I have placed a combo
box. I would like the user to be able to see the first
column of a Vlookup table and when they pick the desiret
item, it picks then displays the other items from the
choice into cells.

E.g. Product code in column A, Description in Column B of
VLookup table on Sheet 2

The ComboBox displays the contents of Column A. The user
choose it and it places this choice on Sheet 1 in cell A1
and the description from Column B into Sheet 1 cell B1.
Does this make sense.

So.. how do I code it or where would you recommend I look
for this information? I have ComboBox1 on my userform.

Thanks!
Shauna