Adding a combo box to a worksheet

  • Thread starter Thread starter Christy Kinder
  • Start date Start date
C

Christy Kinder

Hi all,

I'm re-creating one of our paper forms in Excel and I'd like to add combo
boxes to some blanks on the form to allow the user to choose a name from a
list. I know a little about Excel formulas and no VB code at all...what's
the idiot-proof way to do this?

Thanks,
Chris
 
Hi Chris,

The easiest way is to right-click within Excel in the toolbars area and
select the "Forms" toolbar.

Then Forms toolbar should then appear and could can select the "Combo Box"
icon and click on that. If you can't tell which icon represents the Combo
Box, just hover your mouse over an icon and it will tell you what the icon
is for.

Once you've clicked on the Combo Box icon, click your mouse in the
spreadsheet and draw the shape of the Combo Box that you'd like. Then,
right click on the Combo Box and go to Format Control. On the Control tab
you can then input your range that you'd like. The input range is basically
what you'd like the dropdown to contain. I usually type in the contents in
a bunch of cells in a column and then hide that column so that users can't
see it.

HTH,
Katherine
 
Katherine and Debra, thanks very much. Both your suggestions were very
helpful, and easy to follow.
 
Back
Top