| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete Custom Functions and functions arguments
Hi,
I have custom functions in VBA. I want Excel to show the Autocomplete options as the Microsoft Office Excel displays below the cell a dynamic drop-down list of valid functions, names, and text strings that match the letters or trigger. Also, I want to make the arguments be shown automatically For example, to make clear what i want On pressing =sum for example ( excel automatically shows Sum(Number1, [Number2],...) to help the user on the arguments So, I want my custom function also show the same. Thanks for your reply to may question and the response. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autocomplete Custom Functions and functions arguments
On May 20, 5:15*pm, Subodh wrote:
Hi, I have custom functions in VBA. I want Excel to show the Autocomplete options as the Microsoft Office Excel displays below the cell a dynamic drop-down list of valid functions, names, and text strings that match the letters or trigger. Also, I want to make the arguments be shown automatically For example, to make clear what i want On pressing =sum for example ( *excel automatically shows Sum(Number1, [Number2],...) to help the user on the arguments So, I want my custom function also show the same. Thanks for your reply to may question and the response. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing Constant Arguments to custom Subroutine & Functions | Excel Programming | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Custom functions using arguments with same name | Excel Programming | |||
| Arguments of Excel functions | Excel Programming | |||
| Arrays as Arguments in Functions | Excel Programming | |||
Linear Mode
