+ Reply to Thread
Results 1 to 3 of 3

Auto-complete an entry in drop-down list

  1. #1
    Jason
    Guest

    Auto-complete an entry in drop-down list

    In Excel 2003, I need to be able to auto-complete an entry in a drop-down
    list. I have set up a drop-down list that includes over 1000 entries. I would
    like to be able to type the first letter or two and get a list of available
    options from the list that includes those first few letters.

  2. #2
    Debra Dalgleish
    Guest

    Re: Auto-complete an entry in drop-down list

    If you created the dropdown list through Data Validation, it doesn't
    support autocomplete. If you can use programming, there are instructions
    here for adding a combobox from which you can select one of the values
    from the data validation list. In the combobox, you can enable
    autocomplete:

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


    Jason wrote:
    > In Excel 2003, I need to be able to auto-complete an entry in a drop-down
    > list. I have set up a drop-down list that includes over 1000 entries. I would
    > like to be able to type the first letter or two and get a list of available
    > options from the list that includes those first few letters.



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  3. #3
    Jason
    Guest

    Re: Auto-complete an entry in drop-down list

    Thank you for your response. I was afraid my answer would include some
    programming.

    "Debra Dalgleish" wrote:

    > If you created the dropdown list through Data Validation, it doesn't
    > support autocomplete. If you can use programming, there are instructions
    > here for adding a combobox from which you can select one of the values
    > from the data validation list. In the combobox, you can enable
    > autocomplete:
    >
    > http://www.contextures.com/xlDataVal11.html
    >
    >
    > Jason wrote:
    > > In Excel 2003, I need to be able to auto-complete an entry in a drop-down
    > > list. I have set up a drop-down list that includes over 1000 entries. I would
    > > like to be able to type the first letter or two and get a list of available
    > > options from the list that includes those first few letters.

    >
    >
    > --
    > Debra Dalgleish
    > Excel FAQ, Tips & Book List
    > http://www.contextures.com/tiptech.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