Finding a match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 97.

I have a userform which is populated from a list.

I have used the following code :

If comboFrom1.MatchFound Then

Do something

ElseIf Not comboFrom1.MatchFound Then

Do something


However, problems occur when similarnames in the list are populated.

Is there anyone who can assist me please with something which is perhaps
slicker and accurate. Something which only runs when an exact match is found
from the list.

Many thanks
 
Mark,

You could have another textbox for the input, and check that value against
the list (I assume on a worksheet?), using the Worksheetfunction MATCH.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Find matches in 2 cols using Collection vs Dictionary 20
Global Variables and Constants 17
Outlook Advanced Search Problems...returns with an Error: Argument 1
Find record in subform 5
Userform combobox: best match on partially typed content? 4
Access Partially match 2 lists 1
match vs .find? What's better/preferred? 7
PLEASE HELP: Index and Match function in Userform to populate fiel 22

Back
Top