Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Autocomplete listbox in form using vba

  1. #1
    Join Date
    14th January 2013
    Posts
    2

    Autocomplete listbox in form using vba

    Hi,

    I am looking for help in excel VBA where I am trying to do autocomplete option in one of the listbox, for example if the list contains all the fruit's name, I just need to type "Or" to reach Orange or "Str" to see "Strawberry". Like a Combo box, there is no inbuilt property for listbox, so I believe I need to write a separate function to make it possible.

    Need Help.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,509

    Re: Autocomplete listbox in form using vba

    Use a ComboBox
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  3. #3
    Join Date
    14th January 2013
    Posts
    2

    Re: Autocomplete listbox in form using vba

    Hi,

    I need to use Listbox because I want to select multiple items and while selecting want to use autocomplete. So I want autocomplete in list box.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Autocomplete listbox in form using vba

    while selecting want to use autocomplete
    It is impossible to both select and autocomplete at the same time. "Selecting" involves using (normally) the mouse to scroll and choose.
    Autocomplete (normally) is used in conjunction with typed entries.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Filters in a Excel VBA ListBox Form
    By BadStigma in forum EXCEL HELP
    Replies: 3
    Last Post: September 23rd, 2010, 21:38
  2. Mult Choice Listbox Form
    By phoenix101 in forum EXCEL HELP
    Replies: 6
    Last Post: July 22nd, 2007, 00:49
  3. Multiselect Listbox On User Form
    By Carl Jass in forum EXCEL HELP
    Replies: 2
    Last Post: May 17th, 2007, 23:40
  4. Changing Form Listbox On Worksheet
    By bradles in forum EXCEL HELP
    Replies: 5
    Last Post: September 25th, 2006, 11:57
  5. ListBox on a Form
    By Ranger in forum EXCEL HELP
    Replies: 9
    Last Post: March 1st, 2005, 01:15

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
  •  
porno