I have a userform that contains TextBox1, TextBox2,
TextBox3, and ComboBox1.

I have a table of data on Sheet2 Range A2:C52. Now a
value will be entered in ComboBox1. I need a code that
will try to match the value in ComboBox1 with a value in
Range A2:C52 on Sheet2. If a match is NOT found, then do
nothing. If there IS a match with the value in ComboBox1,
then I need for the code to put the corresponding data in
the corresponding TextBoxes. The way it will do this is
as follows:

If the match is in a cell in Column A, then I need it to
put the data in that cell in Column A into TextBox1, and
then the corresponding data in the other 2 cells in the
columns into the corresponding 2 Textboxes.

If the match is in a cell in Column B, then I need it to
put the data in that cell in Column B into TextBox2 and
then the corresponding data in the other 2 cells in the
columns into the corresponding 2 Textboxes.

If the match is in a cell in Column C, then I need it to
put the data in that cell in Column C into TextBox3 and
then the corresponding data in the other 2 cells in the
columns into the corresponding 2 Textboxes.

Its kind of hard to explain so I hope I hope everyone
understands. If more info is required, please let me know.


Thanx

Todd Huttenstine