Combo Box from Controls Tool Bar
Select the Developers Tab =>insert
Select the Combo Box from the controls tool bar(ActiveX)
Create a list for the Combo Box and name the the Range
"List" and the Sheet List
Set the Font, List Fill
Range, and the Linked Cell.
-This example uses C2 as the Linked cell because the combo box is on top of C2
when a selection is made from the combo box, C2 will be what the Combo Box is. Then you can use the formulas using C2
Use C2 as the formula
Select from Combo Box and
the formula will reflect what was chosen.
Load the Example
Active X Combo Box