Function help text
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
|