LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default select data entry by typing first letter which causes drop down list

In one cell I want to quickly select one data value from a long list
of data values located in another part of the spreadsheet. I want to
start typing the first letter and then have excel immediately display
a sublist of all possible data items from the list that begin with
that letter that I typed. Can this be done in Excel? and How?

Thanks for any help or suggestions.
Zorbahu


A ComboBox will cyle through all list iiems that begin will the letter
you type. For example, if there are 3 items that begin with "c" or "C",
continuosly pressing the 'C' key will cycle through each item and
display them in turn.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
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
Select from drop down list via typing text? Excel Novice Excel Worksheet Functions 8 September 11th 08 03:20 PM
how do I set a drop down list to scroll to a letter by typing it? Kelly_Branegan Setting up and Configuration of Excel 1 September 3rd 08 09:51 PM
how do I make drop-down list select based on 1st letter entered? Missykender Excel Discussion (Misc queries) 3 October 6th 05 11:55 PM
can i select from list by typing first letter of word? LISAWATKIN Excel Discussion (Misc queries) 1 May 13th 05 09:31 PM
press letter and go 2 entry begin w letter in data validation drop MCP Excel Programming 1 August 28th 04 05:07 PM


All times are GMT +1. The time now is 11:42 PM.

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

About Us

"It's about Microsoft Excel"