How To Use Combo Boxes in Excel - The Ultimate Guide

Learn: The Quick & easy way How To Use Combo in Excel
In this video, you will learn:
1. How To Use Combo Box in Excel
2.How to use ActiveX control Combo Box in excel
In my last video tutorial, I talked about How to Hide Formulas in Excel and Show Values
In today's video tutorial, I am going to show you How to use Combo Boxes in excel
Combo Boxes in excel are not used for VBA Code but also for Excel spreadsheets. It is available under the Insert option of the Developer menu tab. These boxes are drop-down kinds of elements that allow the user to select any value from the values listed in the Combo Box drop-down list. Select the Combo box option from the Insert drop-down and drop it anywhere in the sheet. And to add the values to the list, click right and select Format Control, and select the input range and cell link.
There are two options for creating a "Combo Box" in Excel:
1. Form Controls "Combo Box": It comes inbuilt with excel. In this type of control box, users cannot make changes to properties.
2. ActiveX Controls "Combo Box": - It is more versatile than form control. In this type of control box, a user can make changes to properties.
In order to distinguish between the two combo boxes, let us look at the following examples -
How to Create Combo Box in Excel
Initial steps before creating a Combo Box in Excel
In case the Developer tab is visible beside the View tab in the Excel Ribbon then,
• Click on Developer, Insert-, select "Combo Box" from either Form Controls or ActiveX Controls options.
In case the Developer tab is not visible beside the View tab in the Excel Ribbon then,
• Click on File, Options.
• "Excel Options" dialogue box will be displayed as shown below. Click "Customize Ribbon". Under the "Customize the Ribbon" drop-down box, select the "Main Tabs" value, though it is selected by default on the right panel. In the "Main Tabs" panel, select the Developer check box. Click Ok.
• You should now find the Developer tab in your Excel Ribbon.
• Now, create a simple list of values in the worksheet to start with, irrespective of the type of "Control Box".
In my own case, I have created this simple table to perform combo box in excel. The first one I am going to talk about is the Form Control Combo Box
Form Controls "Combo Box" in Excel
Here are the steps to create Form Controls Combo Box in Excel
• Go to the Developer tab in the Excel Ribbon, click Insert, and click on "Combo Box" under "Form Controls".
• Click on the Excel Sheet at a location where you want to place the "Combo Box". In my own case, I will select cell C4. You may select the "Combo Box" and drag any of the small squares in the middle of the boundaries or circles in the corners to change the "Combo Box" size.
• Right, click on the new "Combo Box", and select "Format Control". The "Format Control" dialog box will appear.
• Select Control
• Click on the button to the right of the "Input range".
• Select the cell range for the values in the list, which auto-populates the input box. Click on the highlighted button.
• Click OK in the "Format Object" dialog box.
Note: Drop-down lines =8(by default) can be configured to show a number of items in the "Combo Box".
• It Shows 8 number of items in the dropdown list.
• Cell link: Right, click on the new "Combo Box" and select "Format Control". The "Format Control" dialog box will appear.
• Click on the Cell Link Box, then Select the cell range for the values in the list.
• Enter a cell number to display the position of a selected value in the list. In my own case, I want the cell number to display in cell D4. I will select cell D4. This will show the position of months in the list
• Now you will be able to click on the drop-down arrow of the new "Combo Box" to see the list.
How to Delete Form Control Box in Excel
• Go to the Developer tab "Design Mode."
• Select the Form Controls "Combo Box" and press Delete.
In my next video tutorial, I am going to show you how to use ActiveX control Combo Box in excel.
……………………………………………………………………………………………………………………….
Share this video: • How To Use Combo Boxes...
For more simple and easy to follow How to videos,
Click the Link Below to subscribe:
/ @learnexcelwitht
Join this channel to get access to perks:
/ @learnexcelwitht
#combobox #ActiveXcontrolComboBox #Comboboxes
LearnexcelwithT

[@chamodieudonne8920]

This combo box tutorial was uploaded when I needed it most

[@chamococo1889]

Great teaching from this channel at all time

[@dodotajoche8699]

I am always learning something new from this channel. Combo box ☑️ is the way to go.

[@subnven9255]

Good lesson 👍

[@crystalzone20]

Your lessons are always top notch. You can bring someone with zero knowledge about excel to the level of an expert. Keep up the good teachings

[@Justin-kd4pf]

Great tutorial

[@healthandzumbamaster]

Great job 👏🏽

[@dieudonneasong8497]

Learned a lot today. Waiting for the next upload

[@edoskelvin4339]

this is good and enjoyable

[@castom2venture]

Thanks for this great tutorials, really helpful

[@pstevrardkoutreach]

Thank you for the step by step tutorial

[@catemsengeti]

have learn something precious

[@FlorevrardTV]

Thanks much for sharing this. It's really helpful

[@petersoul8429]

VERY WELL EX[LIN, THANKS

[@ebonoee1629]

Great teaching thanks for sharing

[@chiekehtv]

This is really helpful. Thanks for sharing sir.

[@catemsengeti]

i love your lessons so much. i wish you were near i could bring my kid to get that knowledge.

[@learnexcelwitht]

That will great. They can be watching videos and if there's any issue, please send me message here or mail me for solution. Thank you

[@shopping-magasins-decorati87]

Well explained thanks

[@wisdomlifechangertv3235]

Well explained, thanks for sharing

[@realitytvshowsLit]

Explanation made simple. Thanks alot!

[@susanagruzzi1361]

Very interesting thanks so much

[@catemsengeti]

thanks for letting me know

[@pearlkoryo5518]

Frankly going through anything excel makes my head spin 😢 I hope your videos help me through my exam this year I’m counting on you 😢

[@betagist]

thanks for the teaching

[@julietidu1325]

Very interesting, thanks for sharing

[@grandedecouverte3968]

Amazing tutorial 🤝

[@kingasong1790]

Great educative content. Kidos

[@suzannechamo]

Great teaching as always

[@tayeola4909]

GREAT TEACHING

[@evangelinefontem7324]

learning as always

[@osasimade7012]

Thank you for this awareness, very interesting

[@dorcasamen9042]

Very interesting

[@anuevangeline9412]

Wonderful educative content here

[@frankvictor3427]

Very interesting video

[@catessuperrecipes]

great knowledge

[@linusrose8523]

What a wonder lesson

[@catemsengeti]

work well done

[@chamodieudonne8920]

Learning alot from this channel

[@favourede9144]

i love the way you take time to explain

[@rolandtolefac5001]

Great teaching here. Thank you for showing us this tips

[@suzygist]

VERY educative, well explained and elaborated. Keep it up

[@suzyfarms]

Great learning as usual. Keep it up

[@comfortforlife]

very elaborated tutorial, thx for sharing!

[@legitedogirltv]

This one is really educative and understandably thanks for sharing

[@catemsengeti]

you are really a teacher

[@linusrose8523]

Great lecture indeed. Thanks for the lessons

[@achalekeawung9400]

Another great lesson again

[@julianajulieinn8027]

nice video

[@catemsengeti]

Thanks bro for that piece of education

[@subnven9255]

Well explained as usual

[@alisonforlemu2849]

You doing a great job 👏

[@suzyawung2895]

Great content as always

[@friksachaleke6553]

Learning everyday here

[@mendimcsieh2408]

Combo box well explained

[@waleedibrahim4558]

Thank you for your informative videos. I have a particular case in excel in which I couldn’t find any solution to it and I hope you can help me with it. If I have various numbers in column B, and I need these numbers to be (increased/decreased): • By 0.5 either to make it 20.5 or 19.5 • Or by 1 to make it either 21 or 19 • Or 2 to make it 22 or 18 …etc. • The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example: • The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5 • The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12 • The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is. I hope you can find time to answer this very soon. Thanks again.

[@learnexcelwitht]

Thank you for visiting. You can send me a mail to get the solution across to you with examples and templates

[@waleedibrahim4558]

@@learnexcelwitht thank you for your reply

[@waleedibrahim4558]

@@learnexcelwitht Kindly, what is your email so I can send you the file?

[@sharondestiny826]

Very interesting

[@linusnkem-acha5150]

Great teaching as always