simple VBA question

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

*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
 
Use a combobox from the control toolbox toolbar - check the matchentry
property and the matchrequired property
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Firing Event in another user form 1
userform and inputboxes 1
First blank cell 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to calculate data that is entered into a text box 1
Autosize 2
referring to texbox 4
Multiple labels on userform 2 update 2

Back
Top