Drop-Down Lists, Buttons, and Other Controls

Drop-Down Lists, Buttons , and Other Controls

You can add controls to your spreadsheets, such as drop-down lists and buttons, that are attached to macros that were recorded or written in StarBasic or JavaScript. You're only limited by your imagination in how you can use controls in your spreadsheets.

This sections describes two possibilities for using controls in spreadsheets: adding a drop-down list that lets you select from a predefined list of values to populate a cell ; and adding buttons that let you sort spreadsheet columns in ascending or descending order by clicking them.

Even though these sections give you the specific procedures for implementing these controls, the principles and mechanics are the same for setting up controls using other scenarios.

For full details, see Chapter 36, Creating and Using Forms, Controls, and Events , on page 921.