+ Reply to Thread
Results 1 to 5 of 5

Is there a way to forward type in excel

  1. #1
    Valued Forum Contributor
    Join Date
    11-16-2004
    Location
    Devon UK
    MS-Off Ver
    2010
    Posts
    357

    Is there a way to forward type in excel

    I'm not sure if I have the right terminolgy for this but what I am asking is there a way to complete a cell or offer suggestions from a list words as the user starts to type

    for example as the user types LO it brings up LONDON from the city list ?

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Is there a way to forward type in excel

    in general... not the way i think you are wanting it to work...i assume you want it like google search AutoComplete/Autosuggest

    you can do autocorrect...add LO replaces with LONDON....however this isnt the drop down from list
    and it is very time consuming to create and maintain

    With data validation it is plausible
    you type in first (few) letter the DV changes to only with these letters

    however.....there is quite a lot of background work to set it up
    http://www.excelforum.com/excel-gene...alidation.html
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-25-2012
    Location
    Chatham, Ont, Canada
    MS-Off Ver
    Excel 2019
    Posts
    1

    Re: Is there a way to forward type in excel

    This thread might help you out.

    http://www.excelforum.com/showthread.php?t=1079753

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Is there a way to forward type in excel

    There's an add-in at https://app.box.com/shared/ono8ni9xvr, a read-me at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34 to do this.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Is there a way to forward type in excel

    Neil Firth has a You Tube video for a searchable dropdown list usng formulas. Here is the link. I have used it many times and like it a lot.


    HTML Code: 
    https://www.youtube.com/watch?v=vkPoViUhkxU
    Jim O

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Web-type Back and Forward navigation between Excel worksheets
    By LowerOly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  2. [SOLVED] Web-type Back and Forward navigation between Excel worksheets
    By LowerOly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Web-type Back and Forward navigation between Excel worksheets
    By LowerOly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. [SOLVED] Web-type Back and Forward navigation between Excel worksheets
    By LowerOly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Web-type Back and Forward navigation between Excel worksheets
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1