Microsoft Office Tutorials and References
In Depth Information
Creating an Add-In
‘If no OptionButton was selected:
MsgBox “No Action option was selected”, , _
“Please select an option”
‘Close the Select Case structure.
Private Sub cmdExit_Click()
Create a small macro to call the UserForm. From the VBE menu bar, click Insert ➪ Module and
enter the following macro:
Private Sub SheetManager()
After completing the VBA functionality that your add-in will provide to its users, it’s almost time to
convert the workbook to an add-in. There is an additional step you can take to add a description to
the file’s Properties information. It’s purely optional that you do this, but it’s a good habit to get into
because it will help the add-in’s users know what the add-in does.
The process for accessing the file’s Properties information depends on your version of Excel. To
access the Properties dialog box in Excel versions prior to 2007, click File ➪ Properties from the
worksheet menu bar as shown in Figure 22-2. In the Properties dialog box, some fields may already
be entered for you by default. As you will see later in this lesson, the most useful information to
enter is the Title and Comments fields, as indicated in Figure 22-3.