View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rahul rahul is offline
external usenet poster
 
Posts: 13
Default 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