Explaining an addin

[Guest]

How do I define the arguments in an Excel Addin function that I created? When I bring up a built in Excel function
it does have an expalantion of the arguments. How do I do it for my add-ins? I 'm using Office 2003.

 

[Guest]

Let's learn by examples! Below are two custom worksheet functions created using VBA

The first example is a simple function for finding out whether a specific year is a leap year. Observe the syntax for the use of arguement, and also the definition of the value type for the function. (Here, the function returns a Boolean value, either TRUE or FALSE.

'------------------------------------------------
Function ISLEAPYEAR(ByVal year_input as integer) As Boolea
If year_input Mod 4 <> 0 The
ISLEAPYEAR = Fals
ElseIf year_input Mod 400 = 0 The
ISLEAPYEAR = Tru
ElseIf year_input Mod 100 = 0 The
ISLEAPYEAR = Fals
Els
ISLEAPYEAR = Tru
End I
End Functio
'------------------------------------------------

The second example finds out the "standard font" defined in Excel. Here, there is an "Optional Arguement". See the syntax and how to define a "default value" for the optional arguement

'------------------------------------------------
Function STDFONT(Optional show_size As Boolean = False) As Strin
'the optional arguement decides whether the standard font size is also shown
STDFONT = Application.STANDARDFON
If show_size = True Then STDFONT = STDFONT & " " & Application.STANDARDFONTSIZE & "pt
End Functio
'------------------------------------------------

Also, you may have a look at the Excel VBA on-line help. Look for the key word "Function statement"


----- EMR Tech wrote: ----

How do I define the arguments in an Excel Addin function that I created? When I bring up a built in Excel functio
it does have an expalantion of the arguments. How do I do it for my add-ins? I 'm using Office 2003

 

[Tom Ogilvy]

This basically isn't supported in VBA.

You might look at some of the work Laurent Longre has done on this. The
second reference is his newest:


http://longre.free.fr/english/func_cats.htm
the above appears to be a special case and only works with two arguments -
from what I have heard.


http://longre.free.fr/english/index.html#FunCustomize

--
Regards,
Tom Ogilvy

How do I define the arguments in an Excel Addin function that I created?

When I bring up a built in Excel function

it does have an expalantion of the arguments. How do I do it for my

add-ins? I 'm using Office 2003.