Only if you use the function wizard to insert the function and supply help
for the arguments of a function. This can't be done with VBA alone. You
can use Larent Longre's addin free addin to assist.
http://xcell05.free.fr/
There is no option for it to work like autosense, however.
--
Regards,
Tom Ogilvy
"quartz" wrote in message
...
I am using Office 2003 on Windows XP.
Suppose you have a custom public function which requires certain
arguments.
Suppose further that one of those arguments could be one of three choices.
When you call the function and open the parentheses you see the listed
arguments. Is it also possible to show the three possible choices for the
one
argument?
Is so, could someone please illustrate how to do this? See example
function
below:
Public Function CalculateValue(argItem1, argItem2, argType) as Long
If argType = "Normal" then ...
If argType = "Modified" then ...
If argType = "None" then ...
End Function
When I'm entering a call to the function as in: Call
CalculateValue(lngValue1, lngValue2, ...), when I get to the point where I
need to enter the "argType" I want to see what my options are (i.e.
Normal,
Modified, or None). Kind of like auto-sensing.
Can this be done? If so, how? Thanks much in advance.