simple VBA question
 

*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

simple VBA question
 

Use a combobox from the control toolbox toolbar - check the matchentry
property and the matchrequired property


--
Regards,
Tom Ogilvy


"abxy " wrote in message
...
*sighs* ok, here's what i'im trying to do...

i'm trying to make label1 "agree or disagree" with what's put in
textbox1. By that I mean, if I type "candy" in textbox1, I want label1
to "look" through column A of Sheet2 to find the cell with the word
"candy" in it, then label1 displays the value of the cell to the right
of the cell with the word "candy". if there is no word "candy" in
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 the
real practice, i'm going to enter product ID's in the textbox, and the
label is supposed to let me know if it actually is a valid product ID
as i type it in.

Thanks in advance for any and all help


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

simple VBA question
 

huh

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