combobox vs. listbox

AllenL · Mar 25th, 2002, 11:20 AM

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

dk · Mar 25th, 2002, 11:57 AM

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

AllenL · Mar 25th, 2002, 12:13 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 11:20 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 25th, 2002, 11:57 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Mar 25th, 2002, 12:13 PM	#3
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Thanks dk do you know any tutorial website that I can learn how to create combobox? I am new in VBA Thanks in advance