+ Reply to Thread
Results 1 to 3 of 3

Combobox auto-predict dropdown list

  1. #1
    Forum Contributor
    Join Date
    01-12-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    118

    Combobox auto-predict dropdown list

    I want to have a combobox drop down list that auto- predicts the list for any cell that I click on that has data validation. This list can be very long, so this would be helpful to shorten the search time. It would also be great to make the list font bigger and have more items fit on the list.

    I was trying to follow this youtube video which pretty much has what I want (needs to be excel 2010 compatible).
    https://www.youtube.com/watch?v=vOOuSe_s6pQ

    I have added a template version of mine, but unsure why it is not working like it is in the video?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Combobox auto-predict dropdown list

    Correction in red

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-12-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    118

    Re: Combobox auto-predict dropdown list

    Thanks so much Bo_Ry

+ 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: 16
    Last Post: 04-26-2018, 04:18 AM
  2. ComboBox DropDown List Not Working Correctly
    By lsantana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2018, 09:58 AM
  3. [SOLVED] Dropdown List in ComboBox
    By aearce2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2014, 06:26 PM
  4. [SOLVED] Combobox dropdown to list range from sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2013, 12:35 PM
  5. Combobox Dropdown List only shows first Item
    By Guido Meng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 09:49 PM
  6. dropdown list/ComboBox
    By tullemann in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2011, 01:44 PM
  7. ComboBox dropdown for a large list
    By irish1two3 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-15-2007, 06:11 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