Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paramters or Argument Auto-Label/Balloon Tip for User-Defined Func
This link may be helpful to you:
http://www.dicks-blog.com/archives/2...on-with-excel/ I don't know if Excel 2007 has provided a good way for you to define help for a UDF. Hope this helps, HUtch " wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paramters or Arugment Auto-Label for User-Defined Function | Excel Worksheet Functions | |||
User function argument question | Excel Programming | |||
Function (array argument, range argument, string argument) vba | Excel Programming | |||
Argument limit on user Function? | Excel Programming | |||
Office Assistant Balloon User Input | Excel Programming |