Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
Is there any way to have an Alphabetic lookup within a pick box? I have a
long list of data and it would help to have the list shorten up based on a the spelling of the name. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
If your data is sorted, then you could use the Combobox from the Control
Toolbox toolbar. -- Regards, Tom Ogilvy "Mathew" wrote: Is there any way to have an Alphabetic lookup within a pick box? I have a long list of data and it would help to have the list shorten up based on a the spelling of the name. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
Tom: I'm new at this could you help me a little more on comboboxs. I read
the help file but it didn't really help me! "Tom Ogilvy" wrote: If your data is sorted, then you could use the Combobox from the Control Toolbox toolbar. -- Regards, Tom Ogilvy "Mathew" wrote: Is there any way to have an Alphabetic lookup within a pick box? I have a long list of data and it would help to have the list shorten up based on a the spelling of the name. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
if it's sorted you can use one of the matchentry properties for the combobox:
select the cobobox and press F4. look for matchentry fmMatchEntryFirstLetter 0 Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. FmMatchEntryComplete 1 Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). FmMatchEntryNone 2 No matching. -- Gary "Mathew" wrote in message ... Tom: I'm new at this could you help me a little more on comboboxs. I read the help file but it didn't really help me! "Tom Ogilvy" wrote: If your data is sorted, then you could use the Combobox from the Control Toolbox toolbar. -- Regards, Tom Ogilvy "Mathew" wrote: Is there any way to have an Alphabetic lookup within a pick box? I have a long list of data and it would help to have the list shorten up based on a the spelling of the name. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
Notice:
FmMatchEntryComplete 1 Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). says it is the default - This appears to be what the OP wanted so it should require no additional action beyond assigning a sorted range of values in the ListFillRange property. -- Regards, Tom Ogilvy "Gary Keramidas" wrote: if it's sorted you can use one of the matchentry properties for the combobox: select the cobobox and press F4. look for matchentry fmMatchEntryFirstLetter 0 Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. FmMatchEntryComplete 1 Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). FmMatchEntryNone 2 No matching. -- Gary "Mathew" wrote in message ... Tom: I'm new at this could you help me a little more on comboboxs. I read the help file but it didn't really help me! "Tom Ogilvy" wrote: If your data is sorted, then you could use the Combobox from the Control Toolbox toolbar. -- Regards, Tom Ogilvy "Mathew" wrote: Is there any way to have an Alphabetic lookup within a pick box? I have a long list of data and it would help to have the list shorten up based on a the spelling of the name. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetic lookup within a pick box
know that, but who knows what options have ever been changed, so i just pointed
out where the option was for his knowledge. -- Gary "Tom Ogilvy" wrote in message ... Notice: FmMatchEntryComplete 1 Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). says it is the default - This appears to be what the OP wanted so it should require no additional action beyond assigning a sorted range of values in the ListFillRange property. -- Regards, Tom Ogilvy "Gary Keramidas" wrote: if it's sorted you can use one of the matchentry properties for the combobox: select the cobobox and press F4. look for matchentry fmMatchEntryFirstLetter 0 Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. FmMatchEntryComplete 1 Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). FmMatchEntryNone 2 No matching. -- Gary "Mathew" wrote in message ... Tom: I'm new at this could you help me a little more on comboboxs. I read the help file but it didn't really help me! "Tom Ogilvy" wrote: If your data is sorted, then you could use the Combobox from the Control Toolbox toolbar. -- Regards, Tom Ogilvy "Mathew" wrote: Is there any way to have an Alphabetic lookup within a pick box? I have a long list of data and it would help to have the list shorten up based on a the spelling of the name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto alphabetic | Excel Worksheet Functions | |||
Would I use "Lookup" to pick names for a Christmas grab bag | Excel Worksheet Functions | |||
how can I set up an alphabetic sequence? | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
alphabetic order | Excel Programming |