Finding a match
 

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

Finding a match
 

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)


"Mark" wrote in message
...
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