Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.

Joe

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 10:10:14 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.

Thanks very much Gord

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Joe

You can add a brief description(not arguments) if you open the VBEditor
and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 10:10:14 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a
brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.

Hi Gord,

I've had a play with this add-in, and it works well, but I would like to
know how to do this myself from first principles. Also, adding the comments
in the object browser doesn't appear to be working - the comment isn't being
saved for some reason. Can you help?

Joe.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Joe

You can add a brief description(not arguments) if you open the VBEditor
and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 10:10:14 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a
brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.

Joe

ALT + F11 to get to VBE.

Make sure your add-in is open and listed.

ViewObject BrowserFrom libray dialog select your add-in.

Select the Module in left-side screen.

Find the Function in the list on right-side.

Right-click and Properties

After you typed the short comment into the PropertiesMember
OptionsDescription dialog box, did you save the file?

Can't help at all with the "first principle" item.


Gord


On Fri, 2 Dec 2005 15:28:40 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi Gord,

I've had a play with this add-in, and it works well, but I would like to
know how to do this myself from first principles. Also, adding the comments
in the object browser doesn't appear to be working - the comment isn't being
saved for some reason. Can you help?

Joe.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Joe

You can add a brief description(not arguments) if you open the VBEditor
and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 10:10:14 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a
brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.

Joe

ALT + F11 to get to VBE.

Make sure your add-in is open and listed.

ViewObject BrowserFrom libray dialog select your add-in.

Select the Module in left-side screen.

Find the Function in the list on right-side.

Right-click and Properties

After you typed the short comment into the PropertiesMember
OptionsDescription dialog box, did you save the file?

Can't help at all with the "first principle" item.


Gord


On Fri, 2 Dec 2005 15:28:40 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi Gord,

I've had a play with this add-in, and it works well, but I would like to
know how to do this myself from first principles. Also, adding the comments
in the object browser doesn't appear to be working - the comment isn't being
saved for some reason. Can you help?

Joe.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Joe

You can add a brief description(not arguments) if you open the VBEditor
and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 10:10:14 +1000, "Joe Carroll"
<joeInsertTheAtcarroll-acoustics.net.au wrote:

Hi All,

I've asked this a long time ago, forgot to record the answer somewhere
permanent and am now sheepishly asking again.
I have a number of custom functions in an add-in. I want to display a
brief
explanation of the functions at the bottom of the function wizard dialogue
box eg, Excels function Roundup() displays "Rounds a number up, away from
zero."

Thanks in advance.