Using Learn Mode in Spread Designer

Overview

In other programs you might have used a macro recorder to record a series of actions and create the macro code to let you repeat those actions. The Spread Designer offers a similar feature that records the settings and actions you have made in the Spread Designer and creates the code for those settings and actions.

Spread Designer's learn mode generates Visual Basic code and writes that code to the Clipboard. You can view the code on the Clipboard and you can paste the code into your project. You might want to use learn mode to generate code for an unfamiliar property or to test a new application.

Note: Learn mode generates code only for the settings made through the Spread Designer dialogs. Learn mode does not record actions such as resizing columns using the mouse or typing text in a cell.

Tip: The information that is recorded during learn mode is stored in an internal buffer while learn mode is active. When you exit learn mode, the buffer immediately places the information on the system Clipboard. You should move the information on the Clipboard to your new application or another file as soon as possible to avoid accidentally overwriting it.

Before you use learn mode, you must provide the Spread Designer with the name of the form, the name of the control, and the name of the data source, if one is available. This information provides the names for the objects in the generated code. In addition, you can specify whether or not you want comments in the generated code and whether you want to be notified when the code is sent to the Clipboard.

The status bar displays the mode status.

Return to the overview of Understanding Designer Modes.