My comments are related to using a custom function in a worksheet.

I believe Chip's relate to using it in the VBE. But, he may know something
I don't.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:O99JwZaSFHA.244@TK2MSFTNGP12.phx.gbl...
> 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" <quartz@discussions.microsoft.com> wrote in message
> news:771F5A56-CF5F-42DD-B277-09E093589101@microsoft.com...
> > 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.
>
>