Combobox query?

[Greg B]

Hi all,

I am using a combobox to lookup names in a list. How can i set up the
userform so when the user types in the letter b for example it shows just
the names starting with the letter b.

Thanks in advance

Greg

[Tom Ogilvy]

That isn't supported.

Closest you can come is, if you have a sorted list, moving to that section.

See the MatchEntry property in Help.

--
Regards,
Tom Ogilvy


"Greg B" <tam71@ihug.com.au> wrote in message
news:dv4jvb$73q$1@lust.ihug.co.nz...
> Hi all,
>
> I am using a combobox to lookup names in a list. How can i set up the
> userform so when the user types in the letter b for example it shows just
> the names starting with the letter b.
>
> Thanks in advance
>
> Greg
>
>

[Greg B]

Yeah Thanks Tom I guess as much. I have done it that way and got it
working.

Thanks
Greg
"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:%23YPgxOuRGHA.4792@TK2MSFTNGP14.phx.gbl...
> That isn't supported.
>
> Closest you can come is, if you have a sorted list, moving to that
> section.
>
> See the MatchEntry property in Help.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Greg B" <tam71@ihug.com.au> wrote in message
> news:dv4jvb$73q$1@lust.ihug.co.nz...
>> Hi all,
>>
>> I am using a combobox to lookup names in a list. How can i set up the
>> userform so when the user types in the letter b for example it shows just
>> the names starting with the letter b.
>>
>> Thanks in advance
>>
>> Greg
>>
>>
>
>