Populate Useform LostBox or Combobox Numerous techniques for performing this seeemingly complex task. For all general questions relating to Excel but not including VBA or formulas. I need a workbook to display the Combobox List Dropdown when it opens. The combobox in the Workbook is a form control, so a shape. Cant seem to find the associated. Hi All. I was wondering if someone would kindly help me. I am creating a Userform a need to create a dependent list in a combobox i. When a category is selected. Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook Free Course. Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. This second post on Userforms covers all the common VBA controls and show the best way to use them. Each control has a quick table for easy reference. Stephen Bullens Excel Page, containing many tools and examples for Microsoft Excel. Heres what I want to do. I have a big list of stuff in a sheet. I want to add all those lets say are names names to a VBA combobox but I want only unique records. Types of Excel Drop Down Lists Compared. At a clients office last week, I was selecting a pricing option from a data validation drop down list. The worksheet was zoomed to 7. How can you even read thatGood question. Sometimes the font in a data validation drop down is so small that you can barely read the list. Unfortunately, theres no way to make the font size bigger, which is one of the drawbacks of a data validation drop down list. Excel Vba Combobox Before Update Vba' title='Excel Vba Combobox Before Update Vba' />There are other ways to create a drop down list though, and one of those options might work better in your worksheet. Well compare these types of Excel drop down lists Data Validation List. Form Control Combo Box. Active. X Control Combo Box. Data Validation List. Data validation is a great feature, and you can use creative formulas to create flexible lists, such as dependent drop down lists. However, the font size cant be changed, only 8 rows are visible at a time, and only the active cell shows a drop down arrow. You cant change those settings, but you can colour the data entry cells, to make them obvious to the worksheet users. Form Control Combo Box. Instead of using data validation, you could use a Form Control Combo Box. It gives you a bit more control over the appearance of the drop down list. You can adjust the number of drop down lines in the Form Control Combo box, so you can show all 1. You can also link the combo box to a cell, so the selected item number appears on the worksheet. The drop down arrow is always visible, so the Form Control combo box is easy for users to find on the worksheet. The font size cant be changed though, so the list would be hard to read on a zoomed worksheet. You cant type in the box, so click the arrow, then select an item from the list. That items index number its position in the list is entered in the linked cell. In the screen shot above, February was selected, and a 2 is entered in cell D5. To show the item name, instead of the item number, you can use an INDEX function in another cell. In this example, the INDEX function returns a month name from the Month. List named range, from the row number 2 for the selected month February. Active. X Combo Box. Another drop down list option is to use an Active. X combo box. This is similar to the Forms Control combo box, but has more properties that you can adjust. After you insert a combo box, right click the combo box, and click Properties. You can set the properties, such as font, font size, number of rows, and even include multiple columns. If you know that a worksheet will be zoomed most of the time, you can use a larger font, to make the list easier to read. Free Software Download Sites List. This combo box can also be linked to a worksheet cell, and the value is entered in that cell, when you select an item from the list. Also, you can type in the combo box, and the text autocompletes as you type, finding the first matching item in the list. Combine the Drop Down Lists. To make the most of the data validation features, while allowing font changes, autocomplete and more rows, I sometimes combine data validation with a combo box. Theres only one combo box, hidden at the top of the worksheet, and bit of programming makes the combo box appear when needed. When a user double clicks on a data validation cell, the combo box appears, and displays the data validation list for the selected cell. If users dont want to use the combo box, they can simply click on the arrow in the cell, and use the data validation list. Watch the Drop Down Lists Video. To see a demonstration of the 3 types of drop down lists, you can watch this Drop Down Lists video. Or watch on You. Tube Compare 3 Excel Drop Down List Types.