How to Setup an Active X ComboBox List

👉 Up4Excel Downloads Library: »» https://ml.up4excel.com/library
📗 Free Workbook Download: »» https://cutt.ly/up4v2012S01FD
🎯 Active X ComboBox Lists can be used for so many things they're a must know tool for your Excel toolkit…..AND easier to setup than you think…plus massively configurable.

======================================================================================
🥉 You can make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list.

Combo box: You can add a Form Control or an ActiveX Control combo box. If you want to create a combo box that enables the user to edit the text in the text box, consider using the ActiveX Combo Box. The ActiveX Control combo box is more versatile because, you can change font properties to make the text easier to read on a zoomed worksheet and use programming to make it appear in cells that contain a data validation list.

Pick a column that you can hide on the worksheet and create a list by typing one value per cell.
Note: You can also create the list on another worksheet in the same workbook.
Click Developer » Insert.
Note: If the Developer tab isn't visible, click File » Options » Customize Ribbon. In the Main Tabs list, check the Developer box, and then click OK.
Pick the type of combo box you want to add:
Under ActiveX Controls, click Combo Box (ActiveX Control).
Insert combo box
Click the cell where you want to add the combo box and drag to draw it.

======================================================================================
#Up4Excel
#Up4ExcelControls
#Up4ExcelIntermediate

Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time

Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.

You get new video releases every week, packed full of ways to save time and impress those around you.

💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾
https://cutt.ly/Up4ExcelSub

======================================================================================
👀 Learn more with my playlist: Excel Dropdown List Tips and Tricks
»»    • Excel Dropdown List Tips and Tricks  

💥 Get a Shortcuts Cheat Sheet: »» http://www.up4excel.co.uk/shortcuts
🔑 Remove Excel File Open Passwords: »»    • Excel File Locked? Learn How to Break...  

🎁 Your small gift will help me make better videos for you and others.
Thank You: https://www.paypal.me/Up4Excel

👉 All Up4Excel workbooks and templates on YOUR device in a structured searchable index….with free lifetime updates
📕 Up4Excel Downloads Pack: »» https://ml.up4excel.com/downloads_pack