How to write code for this:
Find last cell of Col A of w/sheet used range and match a value of of
userform.textbox1 , loop from last row to first row of used range,if match
found fetch Col B value to userform.textbox2.
Say my usedrange is A1:C123,goto A123 ,match "Xyz"(textbox1 value) loop
through A123 to A1 ,find match.

--
Message posted via http://www.officekb.com