Edit the Control Properties

All Combo Boxes need a reference table to look up the values. Earlier in our lesson, we created a table and named the range Clients.

 

3. Try it: Edit the Control Properties

Click once on the Combo Box to select it.

Go to Developer ->Controls.

Click on Properties.

 

What Do You See? Each Control has Properties that you can edit. The Properties include Size, Protection, Properties, Alt Text and Control.

 

Try This, Too: Edit the Input Range

Input Range: Clients

 

Click OK. Keep going...!

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.2. Insert and manipulate form controls

Developer ->Controls ->Properties