+ Reply to Thread
Results 1 to 7 of 7

How to autosuggest words when typing

  1. #1
    Registered User
    Join Date
    10-08-2015
    Location
    Gothenburg
    MS-Off Ver
    2016
    Posts
    78

    How to autosuggest words when typing

    Hey guys.

    Been searching around and never found a good way to solve this.

    I got about 40 different cities I want to search about. I got a dropdown list so I can easily find them, I can also type in the correct name, I would like excel to autosuggest from the list. So when I start to typ for ex. "Kar" I want it to fill in "kareby"

    Is there anyway to make that specific droplist feel what I'm typing?

    Below are the cities.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: How to autosuggest words when typing

    Welllll, you can always paste that list to A1:A33, then on A34 when you type "Kar" it should suggest "Kareby" :D
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Registered User
    Join Date
    10-08-2015
    Location
    Gothenburg
    MS-Off Ver
    2016
    Posts
    78

    Re: How to autosuggest words when typing

    That trick I know of. But I don't got any space to put text in above where I want my dropdownlist :P

    Quote Originally Posted by Lemice View Post
    Welllll, you can always paste that list to A1:A33, then on A34 when you type "Kar" it should suggest "Kareby" :D

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to autosuggest words when typing

    You can do this with an ActiveX combo box. It has an autocomplete property.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Registered User
    Join Date
    10-08-2015
    Location
    Gothenburg
    MS-Off Ver
    2016
    Posts
    78

    Re: How to autosuggest words when typing

    Followed the link below and it seemed to work. Is there any setting to make it choose the suggested word by pressing enter?
    HTML Code: 
    Quote Originally Posted by Tony Valko View Post
    You can do this with an ActiveX combo box. It has an autocomplete property.

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to autosuggest words when typing

    That technique uses a combo box and data validation drop down list combined.

    If you use just the combo box you can simply hit Enter for the suggested word.

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

    Re: How to autosuggest words when typing

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

+ 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. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  2. Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  3. spellnumber formula for arabic amount in words by typing digits
    By mehmoud hussain in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-10-2014, 08:22 AM
  4. Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  5. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  6. Autosuggest
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 01:20 AM
  7. Allowing macro to run while typing words into cells
    By Cellar Webs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2007, 02:20 PM

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