Announcement

Collapse
No announcement yet.

Autocomplete listbox in form using vba

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    Re: Autocomplete listbox in form using vba

    Use a ComboBox
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    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.

    Comment


    • #3
      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.

      Comment


      • #4


        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

        Comment

        Working...
        X