Automatically select combo box possible selections

Hi Everyone new user here!!
I have a large list of clients in a list, i tried to use a combo box in order to be 100% sure that the Name entered is the right one. Is there any way to to it like when we use the help in office? i.e. i can type Mac in the cell and in the combo box the date appears the options starting with those letters .. Mac Arthur, Mac Belle, Morgan, and so on til the Z.

thanks in advance to all.

Mike_can

Hi,

I put a combobox on a sheet, added an alphabetized list
of names, and set the property "MatchEntry" to
"1-fmMatchEntrycomplete" and got pretty much what
you're after. Try it.

jeff


-----Original Message-----
Hi Everyone new user here!!
I have a large list of clients in a list, i tried to use
a combo box in order to be 100% sure that the Name
entered is the right one. Is there any way to to it like
when we use the help in office? i.e. i can type Mac in
the cell and in the combo box the date appears the
options starting with those letters .. Mac Arthur, Mac
Belle, Morgan, and so on til the Z.

thanks in advance to all.

Mike_can
.

Thnx a lot Jeff.

Do you know how limit the entries to the ones detailed in the list?
(I don't want the users to enter information inte combo box, just to select the ones that may apeor on the list.)


"jeff" wrote:

Hi,

I put a combobox on a sheet, added an alphabetized list
of names, and set the property "MatchEntry" to
"1-fmMatchEntrycomplete" and got pretty much what
you're after. Try it.

jeff


-----Original Message-----
Hi Everyone new user here!!
I have a large list of clients in a list, i tried to use
a combo box in order to be 100% sure that the Name
entered is the right one. Is there any way to to it like
when we use the help in office? i.e. i can type Mac in
the cell and in the combo box the date appears the
options starting with those letters .. Mac Arthur, Mac
Belle, Morgan, and so on til the Z.

thanks in advance to all.

Mike_can
.