*sighs* ok, here's what i'im trying to do...

i'm trying to make label1 "agree or disagree" with what's put i
textbox1. By that I mean, if I type "candy" in textbox1, I want label
to "look" through column A of Sheet2 to find the cell with the wor
"candy" in it, then label1 displays the value of the cell to the righ
of the cell with the word "candy". if there is no word "candy" i
column A of Sheet2, then label1 should display "not found"

How would i begin to code this....under what Sub?

The above is a fundamental example of what i'm trying to do, in th
real practice, i'm going to enter product ID's in the textbox, and th
label is supposed to let me know if it actually is a valid product I
as i type it in.

Thanks in advance for any and all hel

--
Message posted from http://www.ExcelForum.com