Microsoft Office Tutorials and References
In Depth Information
Using the Insert Function Dialog Box
Table 23-1: Function Categories
Category Number
Category Name
0
All (no specific category)
1
Financial
2
Date & Time
3
Math & Trig
4
Statistical
5
Lookup & Reference
6
Database
7
Text
8
Logical
9
Information
10
Commands
11
Customizing
12
Macro Control
13
DDE/External
14
User Defined
15
Engineering
16
Cube
17
Compatibility
Adding argument descriptions
When you use the Insert Function dialog box to enter a function, the Function Arguments dialog
box displays after you click OK. For built-in functions, the Function Arguments dialog box
displays a description for each of the function’s arguments.
In the past, there was no direct way to provide argument descriptions for custom VBA
functions. Excel 2010, however, offers this capability in the MacroOptions method.
In Chapter 25, I present a function named EXTRACTELEMENT:
Function EXTRACTELEMENT(Txt, n, Separator) As String
‘ Returns the nth element of a text string, where the
‘ elements are separated by a specified separator character
Dim AllElements As Variant
AllElements = Split(Txt, Separator)
EXTRACTELEMENT = AllElements(n - 1)
End Function
 
Search JabSto ::




Custom Search