User-Defined Function Help/Variable definition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning

I would like to know how can I create a variable listing for a user defined function

When you use predefined function when you selection a variable a brief explanation is displayed in the msgbox. How can I achieve this for my user-defined functions?

Therefore, if my function involves 2 variable a and b, when I select variable a field it would display an explanation as to what variable a is and when the user selects the variable b field it would display a brief explanation as to what the variable b was

Thank yo

Daniel
 
Hi Daniel
you may use the free Add-in FUNCUSTOMIZE.DLL
available at: http://longre.free.fr/english/

--
Regards
Frank Kabel
Frankfurt, Germany

Daniel P said:
Good morning,

I would like to know how can I create a variable listing for a user defined function.

When you use predefined function when you selection a variable a
Click to expand...
brief explanation is displayed in the msgbox. How can I achieve this
for my user-defined functions??
Therefore, if my function involves 2 variable a and b, when I select
Click to expand...
variable a field it would display an explanation as to what variable a
is and when the user selects the variable b field it would display a
brief explanation as to what the variable b was.
 
Hi Daniel,

Not an easily achieved objective, but this solution from Laurent Longre may
work for you

http://groups.google.com/[email protected]

Let us know if it works and is stable (might use it myself!).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Daniel P said:
Good morning,

I would like to know how can I create a variable listing for a user defined function.

When you use predefined function when you selection a variable a brief
Click to expand...
explanation is displayed in the msgbox. How can I achieve this for my
user-defined functions??
Therefore, if my function involves 2 variable a and b, when I select
Click to expand...
variable a field it would display an explanation as to what variable a is
and when the user selects the variable b field it would display a brief
explanation as to what the variable b was.
 
Hi Bob
I use Laurent's add-in (which probably uses these techniques). Found it
quite stable/robust
 
From what I have seen posted in this group,
It is pretty much limited to the situation presented in the code.
The addin cited by Frank is Laurent's latest.
 
Hi Frank,

This requires running a DLL though as I understand, which I personally would
like to avoid for when I distribute the code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top