Lookup part of textstring in Userform ComboBox and search for value in sheet range

[Michael2008]

Hi guys,

I have a worksheet with following values:

	A	B	C
1	Shorts	75
2	Pants	25
3	Socks	34
4	Shirt	10

<tbody>
</tbody>

Also I have a Userform with 2 ComboBoxes named "ComboBox1" and "ComboBox2". Values in ComboBox1 is "Pull my pants", "Eat my shorts", "Socks for everyone".

What I would like to do is to search though column A and look for any of these textstrings in my selection in ComboBox1 and return the value from column B in column C.

Example: "Pull my pants" is selected in ComboBox1 then the value "pants" should be found in column A and value in column B (25) should be entered in cell C2.

Does this make sense?

I am fairly new to VBA and have spend hours searching Google and found some formulas like InStr and VLookup. My problem is that I am not sure if these statements will do the job and how to combine them.

Any help and guidance is appreciated.

Thanks in advance

Brgds
Michael