Giving help to the user of my function
 

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...


--
David C.

Giving help to the user of my function
 

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

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


David C. wrote :

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...

Giving help to the user of my function
 

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



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...

Giving help to the user of my function
 

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 :

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



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...

Giving help to the user of my function
 

better?


You bet !

see... it's better when you keep it cool... :)
appologies accepted about the printer macro :) :)

Giving help to the user of my function
 

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 :


better?


You bet !

see... it's better when you keep it cool... :)
appologies accepted about the printer macro :) :)

Giving help to the user of my function
 

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

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...