is there someway to institute autocomplete using a userform? so if the user
starts typing the names or acct number it narrows the selection. or just use
a dropdown. might be used for time of day, too. i am looking for the best
way to populate the userform.

any thoughts?

thanks
--


Gary

I know that the ComboBox Control has an MatchEntry property that can be
set to one of three parameters. One of those is
fmMatchEntryFirstLetter. When this is selected then the combobox jumps
to the area in your list that begins with the same letter entered in
the ComboBox. Other than that I am not aware of a VBA function that
mimics Excel's ability to intuit a user's intention.

that may be ok, thanks

--


Gary


"Mark" wrote in message
oups.com...
I know that the ComboBox Control has an MatchEntry property that can be
set to one of three parameters. One of those is
fmMatchEntryFirstLetter. When this is selected then the combobox jumps
to the area in your list that begins with the same letter entered in
the ComboBox. Other than that I am not aware of a VBA function that
mimics Excel's ability to intuit a user's intention.

Using a comboBox is the way to go with this. And MatchEntry property is
where it is set. I think that using the fmMatchEntryComplete is the best way
to do what you're looking for. Entering the first letter "B" brings up the
first item starting with b in the list. Then you can enter "i" to have the
first item starting with "bi".

fmMatchFirstLetter only lets you select the first item starting with a given
letter, but doesn't narrow things with each additional letter. It just keeps
showing the first item for each letter entered.

Hope that helps


"Mark" wrote:

I know that the ComboBox Control has an MatchEntry property that can be
set to one of three parameters. One of those is
fmMatchEntryFirstLetter. When this is selected then the combobox jumps
to the area in your list that begins with the same letter entered in
the ComboBox. Other than that I am not aware of a VBA function that
mimics Excel's ability to intuit a user's intention.

Gary Keramidas wrote:
that may be ok, thanks

--


Gary


"Mark" wrote in message
oups.com...
I know that the ComboBox Control has an MatchEntry property that can be
set to one of three parameters. One of those is
fmMatchEntryFirstLetter. When this is selected then the combobox jumps
to the area in your list that begins with the same letter entered in
the ComboBox. Other than that I am not aware of a VBA function that
mimics Excel's ability to intuit a user's intention.