View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Andrew.D.Robertson@gmail.com is offline
external usenet poster
 
Posts: 4
Default Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction

Hi,

I am trying to create an auto-label to display the valid parameters
that would appear when you enter a user defined function into a
worksheet, much the same way that a label appears when you type:


"=sum("


and then the following label appears below the active cell:


"Sum(number1, [number2],...)"


I would like a lable like this to appear, with text I define, when I
input my user-defined function into a worksheet. Specifically it is
the automatic text that appears as you type in
the first bracket "(" in the spreadsheet. It's a little blue label
that appears underneath the active cell.


Can anyone help?


Thanks!