Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Aug 29, 12:38*am, GS wrote:
Sorry about the typos... I suspect you're trying to make a combobox work like a 'google' combobox does. Normally, continually pressing the first character of any list item causes the combobox to 'cycle' through all the list items that begin with that character. If the list is 'unique' then you'd get the list item with a single keystroke. I'd expect that to duplicate that behavior with VBA it would result in a serious performance hit to continuously 'filter' the list items one keystroke at a time. It's an interesting concept, though, and I might be able to test ways to accomplish it, ..time permitting! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc I tested many solutions, but found a quick an dirty solution: I use a textbox to enter the search string (=name), I search for that string in the address book (Excel column) and add matches to a separate listbox. It works! With 500 names, fast enough. If you find a more sofisticated way, pls let me know. Hakan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox RowSource Dynamic | Excel Programming | |||
ComboBox.RowSource? | Excel Programming | |||
How do I set the rowsource for a ComboBox for a dynamic list? | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
combobox rowsource | Excel Programming |