Consulting

Results 1 to 1 of 1

Thread: Interactive Drop-down list

  1. #1
    VBAX Regular
    Joined
    Apr 2017
    Posts
    28
    Location

    Interactive Drop-down list

    Hi everyone,

    I'm writing you because I need support. On a Word document I have built a user form with a combobox. The items of the drop-down list are created from an Excel sheet. As the number of items is huge and scrolling down to get to the right option to choose is not always that user-friendly (also because the scrolling with the mouse wheel isn't that quick..) I was wondering if there is a way to see to it that when the user starts typing something in the box, this will determine which items are displayed in the dropdown list when he clicks on the arrow. This way the dropdown list would become "interactive" and dynamic so to speak and it would be much quicker to choose from a much smaller number of options tailored to the search performed in the box.

    The idea is that as soon as you type anything in the search box, it shows only those items that have that text in it.

    You can find the Word document and the Excel file that populates the drop-down list. To test it simply make sure both files are in the same folder/desktop.

    Thank you in advance for your support.

    Regards

    Massimo Ollani
    Attached Files Attached Files
    Last edited by max76; 02-27-2021 at 01:13 PM.

Posting Permissions

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