Combo boxes

Combo boxes are cool! You’ll find that they don’t do anything particularly clever in Excel – all they do is change the value of a simple input. But they can certainly make your model more user friendly and make you look like a pro.

In this lesson we apply combo boxes to running scenarios in a simple imaginary model.

Combo boxes are ‘forms’ that you have to ‘draw’ into your model. So you’ll end up using a hidden tab to create your drop-down boxes (during the lesson you’ll need to open Excel’s developer tab).

Combo boxes

Register for the Excel formulas course

Excel has hundreds of formulas on offer. That can present a bit of a challenge: you need to become fluent in the formulas that are going to be most helpful in financial modelling.

We think that, in just ten minutes a day over a month, we can check that you’re on top of critical Excel financial modelling functions. And we’re happy to help you with Excel formulas for free!