How to use Combo Box (Form Control)

Combo Box is one of the ways to create drop down menu in Excel. More about drop down menus is on http://excel-example.com/other-tutorial/how-to-create-drop-down-menu-in-excel-worksheet.
In this example we create a simple Order Form that calculates final prize. Combo boxes will be used for choosing goods. Here is simple list that will be source for Order Form.
simple list of goods Continue reading “How to use Combo Box (Form Control)” »

How to create drop down menu in Excel worksheet

There are two ways how to insert drop down menu to the sheet. You can use either Data Validation – List or Form Control – Combo Box. Both have their advantages.

Example

The following table represents a simple order form. The task is to create a drop-down menu for selecting the method of payment in the cell E3. Method can be VISA, MASTERCARD or AMERICAN EXPRESS.

Simple order form

Continue reading “How to create drop down menu in Excel worksheet” »

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress