View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
james s shoenfelt james s shoenfelt is offline
external usenet poster
 
Posts: 2
Default Adding a pop-up help to a user-defined function

When I type "=fv(" in cell A1 in Excel 2002, I am greeted with a
"popup window of sorts that gives some clue as to the parameters. In
this case the "popup" reads "FV(rate, nper, pmt,[pv],[type]).

I would like to create similar popup windows for user-defined
functions. Is this possible?

In particular, the user-defined function is:

Public Function WeightedAvg(DataRange As Range, _
WtRange As Range) As Double

WeightedAvg = WorksheetFunction.SumProduct(DataRange, WtRange) /
WorksheetFunction.Sum(WtRange)

End Function


How do I change this function so that I will get greeted with a little
popup that reads "WeightedAvg(DataRange, WtRange)" after I type
"WeightedAvg(" in any given cell?

Jim