Add a Combo Box

Microsoft Excel has several methods for enabling the user to select an item from a list. Data Validation can be used to create an In-Cell Drop Down. Visual Basic programming is another method.

 

1. Try it: Add a Combo Box

Go to Timesheet (2)

Select Cell A2.

Go to Developer ->Controls.

Click on Insert->Combo Box.

 
Keep going, please.

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.2. Insert and manipulate form controls

Developer ->Controls->Insert->Combo Box