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

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

[:) Sixthsense :)]

Two questions from my end:-

Why you need to return col-b value to col-c? Is it cut paste method or copy paste?

What is the use of combobox2?