Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Location
    Gainsborough
    Posts
    20

    Unanswered: Auto-complete in a dropdown list

    Hi guys
    After creating a great form using Excel and the expertise of Shades I am now wondering if it is possible to have a sort of auto complete in a dropdown list box.
    I've done a quick search and found nothing that I can understand!
    Kind regards
    Andy
    Novice Excel Dabbler

  2. #2
    Join Date
    Mar 2008
    Location
    East Anglia
    Posts
    7
    You have to use the combo box which is made available to put on a user form in the vba project - the combo box that you just drop straight onto the spreadsheets from the form controls doesn't have the auto complete property.

  3. #3
    Join Date
    Feb 2008
    Location
    Gainsborough
    Posts
    20
    Ok..thanks for that
    How do I do it?
    Novice Excel Dabbler

Posting Permissions

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