Using controls on worksheets

Introduction

As a frequent spreadsheet user, you will be familiar with the concept of using data entry cells to feed your model with input.

To ease data input, you can use the Data, Validation option (which is NOT discussed in this article).

Sometimes it is more convenient to be able to change the input of your model by using controls you can interact with using e.g. your mouse. Excel offers a range of controls to do this, such as dropdown lists, spinner buttons, option buttons and the like. These user interface elements are called controls -after all, they allow you to "control" Excel-.

This article shows you how you use the form and control toolbox (ActiveX) controls.

Read on...

Content

Insert; how
2 groups
Control types
Description (1)
Description (2)
Description (3)
Description (4)
Conclusion