Results 1 to 3 of 3

combobox vs. listbox

This is a discussion on combobox vs. listbox within the Excel Questions forums, part of the Question Forums category; Hello, I am wondering, if I want to creat the drop down list similar to autofiler, should I use combobox ...

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67

    Default

    Hello, I am wondering, if I want to creat the drop down list similar to autofiler, should I use combobox or listbox?
    Thanks in advance

  2. #2
    dk
    dk is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,932

    Default

    If you want the user to be able to type into the box then use a combobox e.g. if you had a combobox with Aaron, Ben, Dan, Paul in it. As soon as you typed P you can set the combobox to populate with Paul. You can also type entries that aren't in the combobox if the MatchRequired property is set to False. Comboboxes are also probably better for large lists.

    If you are working with a relatively small list and don't want the user to type anything then use a listbox.

    My personal preference would be a combobox.

    Regards,
    D

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    67

    Default

    Thanks dk
    do you know any tutorial website that I can learn how to create combobox? I am new in VBA
    Thanks in advance

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com