Hi
I am writing code for a function which starts as under

Public Function MasterValue(PremiumRate As Double, CashFlow As Range) As
Double

Now, when i use the function in excel, i want to display some help text in
the popup window for entering function arguements. FOr all inbuilt functions
we can see some text describing each field. So what i want is when i have
selected to input PremiumRate in the function input box, some text (which i
put in the code) be visible. Similarly when anyone is entering second
arguement, help text associated with that is visible. How to do that

Thanks

The short answer is that that isn't supported in VBA. You can download a
free addin from Laraunt Longre that might be useful in implementing this.

http://xcell05.free.fr/

Hit the English button and download

FUNCUSTOMIZE.DLL

--
Regards,
Tom Ogilvy


"Rahul" wrote in message
...
Hi
I am writing code for a function which starts as under

Public Function MasterValue(PremiumRate As Double, CashFlow As Range) As
Double

Now, when i use the function in excel, i want to display some help text in
the popup window for entering function arguements. FOr all inbuilt
functions
we can see some text describing each field. So what i want is when i have
selected to input PremiumRate in the function input box, some text (which
i
put in the code) be visible. Similarly when anyone is entering second
arguement, help text associated with that is visible. How to do that

Thanks