Giving help to the user of my function

D

David C.

this time I did not forget anything. I just don't know how to do this...

I made a personnal function (VBA) and I use it in a cell...

i would like to help the user as the usual way:
when he press the "=" icon next to formulas, it open the window with all
arguments, and their names.

this works BUT i would like to change the comment at the bottom of this
window.
I assume it's possible, because when we give a comment when creating a new
macro/function with the Tools/macro menu, we can see this commetn again at
this place in the help-formula window.

But it's uneasy that way. And it does not give details about each argument.
How is it possible to change this from the VBA code ?

thank you again...
 
D

David C.

the only way to do it is to use a utility called FUNCUSTOMIZE.DLL
from Laurent Longre.
http://longre.free.fr/english/
Click to expand...


well, thanks but this is not satisfying my request
Here is a (first) trick

for the moment, I'm recording a false macro this an acceptable comment,
then changing the name (sub -> function) so I have a "quitte good help" with
my function. This is a start, not "clean" but efficient. and this does not
need any dll...
Sure, I still do not give help for each parameter
but a first (big) step is done in my way.

I'm just looking for a better way to record this...
Since Excel save such data (somewhere ?) with macro, I'm looking for a way
to change it, and have it recorded with my file, without re-using such a
dll each time. A dll to register this, I can. To distribute a dll with the
..xls : I can not...
 
K

keepITcool

Descriptions for the function( not the arguments)
can be done as follows:

open object browser
in dropdown select your project
select a function or procedure.
rightclick
select properties
edit the description.

better?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


David C. wrote :
 
K

keepITcool

David.

did you d/l the tray addin?
did it work ok?

it was a first ruddy attempt at building a hierarchical classed object
for the printer/trays etc.

any comments on the thing itself?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


David C. wrote :
 
D

David C.

did you d/l the tray addin?
did it work ok?
Click to expand...

well are you still talking about the function or the printer ?!?
confusing asking it in this thread...

printers: I just used what is given in the articles.
So no comments... I did not try anything. I suppose it was like you said...
 
Top