graphic2
graphic1

Exam 77-428 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.3 Apply Custom Styles and Templates: Create Form Fields

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

Go to the Control Tab.
nput Range: Clients

 

Click OK. Keep going...

Developer ->Controls ->Properties

graphic1