Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Combobox query?

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Combobox query?

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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Combobox query?

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

Thanks
Greg
"Tom Ogilvy" wrote in message
...
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" wrote in message
...
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
ComboBox Filled by Query DBAL[_6_] Excel Programming 3 May 12th 05 02:22 AM
Combobox query Nigel Excel Discussion (Misc queries) 1 April 29th 05 11:56 AM
Tricky ComboBox / Filter query [email protected] Excel Discussion (Misc queries) 0 December 11th 04 10:37 PM
Combobox Query Maxime Maugeais Excel Programming 1 November 17th 04 11:36 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"