+ Reply to Thread
Results 1 to 4 of 4

Drop Down Data Validated AutoComplete In Multiple Cells

  1. #1
    Registered User
    Join Date
    08-27-2018
    Location
    London
    MS-Off Ver
    office 2016
    Posts
    45

    Drop Down Data Validated AutoComplete In Multiple Cells

    Hello

    Currently I have autocomplete set up to work using double click action, how do I set it up so that that extra step is not needed

    I want to be able to just start typing and get autocomplete results and remove that step

    The current set up is with an activex combo box with some code under the sheet American and it requires a double click to activate it

    Can this method be activated with normal text entry (without doubleclick)?

    (Currently normal text entry requires clicking the drop down arrow after entering a partial name to see the narowed down list from the Prices sheet)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Drop Down Data Validated AutoComplete In Multiple Cells

    Here's an example of a searchable combobox (without data validation):

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    Ne/Ia
    MS-Off Ver
    office 2016
    Posts
    52

    Re: Drop Down Data Validated AutoComplete In Multiple Cells

    I currently use code in combination with data validation to be able to select multiple with a comma separation. Can the above solution (without data validation) be used to select multiple?

  4. #4
    Registered User
    Join Date
    12-15-2023
    Location
    NYC, USA
    MS-Off Ver
    2023
    Posts
    2

    Re: Drop Down Data Validated AutoComplete In Multiple Cells

    How can you have it so you can select "Camden Pale Ale" in all cells? I noticed the data validation range changes in each cell for cells C6 thru C21 (the range in the PRICES tab shifts down for each cell for cells C6 thru C21). See attached image
    Attached Images Attached Images

+ 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. Autocomplete Data Validation Drop Down
    By bgrish3 in forum Excel General
    Replies: 3
    Last Post: 02-22-2017, 09:58 AM
  2. Multiple Selection from validated drop down
    By Phil-G in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2014, 02:05 PM
  3. Validate the sum of multiple validated cells
    By danieljksn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 05:45 AM
  4. Replies: 7
    Last Post: 05-27-2013, 03:58 AM
  5. Replies: 1
    Last Post: 06-30-2012, 01:54 AM
  6. Excel 2007 : Drop Down box with autocomplete on cells
    By MARIANA in forum Excel General
    Replies: 4
    Last Post: 01-23-2012, 12:06 PM
  7. Replies: 0
    Last Post: 05-12-2005, 03:06 PM

Tags for this Thread

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