Microsoft Office Tutorials and References
In Depth Information
Removing an Add-In from the Add-Ins List
11.
Click the Browse button and navigate to the folder where you saved the CommentText
add-in file. Select the CommentText file, and click OK. Your Add-Ins dialog box will look
like Figure 22-18, with the CommentText add-in loaded. Recall that the file is named
CommentText but the add-in dialog box shows it as Comment Text, and also shows the
description of the add-in, because that is the information you entered in Step 2 about the
add-in file in its Properties dialog box. Click the OK button to exit the Add-Ins dialog box.
figurE 22-18
12.
In cell G1, enter the User Defined Function =GetComment(B1) and press the Enter key. Copy
the formula down to cell G2. You will see that the UDF returned “No comment” in cell G1
because no comment exists in cell B1. However, you did enter a comment into cell B2 in Step
8, so the UDF in cell G2 returns the text of the comment from cell B2. Your worksheet will
look similar to Figure 22-19.
figurE 22-19
13.
Note that the workbook you are looking at does not contain the GetComment UDF code.
You can utilize that UDF because its code belongs to the CommentText add-in file that you
installed for the active workbook.
To view the video that accompanies this lesson, please select Lesson 22, available
at the following website: www.wrox.com/go/excelvba .
Search JabSto ::




Custom Search