+ Reply to Thread
Results 1 to 2 of 2

Auto Select? in Drop Down List Box help

  1. #1
    Registered User
    Join Date
    01-22-2005
    Posts
    6

    Auto Select? in Drop Down List Box help

    I am trying to create an invoice template and added a drop down list box in the description field to provide valid available product description to select from to avoid typing.
    Problem that I am having is that this only allows me to select description by scrolling down in the list box. I would like to be able to type first couple of letters and have the cursor move down to the correct section to make selection quicker and easier specially since I will have approx 500 different description to pick from....

    Would greatly appreciate any assistance with this request.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Smile Auto Complete Listbox(drop Down)

    Here is a place on Debra's site, it Auto Completes but If I press enter once the word is found it doesn't work, I am sure she will see this post:

    Here's the location of the file select the file I have bolded

    DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled. When the combobox loses focus, the entry is validated. DataValComboCheck.zip 15 kb 29-Jun-06

    http://www.contextures.com/excelfiles.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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