Autocomplete Custom Functions and functions arguments

S

Subodh

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.
 
S

Subodh

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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF does not show up in Autocomplete 4
Displaying the arguments of UDF in the spertip 3
Creating Add-in with library of functions 7
Add-In: Functions and Category 2
Is it possible to make a custom function behave like a built in on 2
KURT and SKEW functions 8
Help file for VBA custom function 2
VBA Excel Function 1

Top