User Defined Functions - Input prompts

G

Guest

We have created a user defined function in VBA which has a number of variables

When we use this function in an Excel sheet we want the yellow prompt box
that you get when you use normal excel functions to appear. This will then
help us to input the formula without having to use the function dialogue box
and so that the variables get inputed in the right order

Thanks
 

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

User Defined Function 5
user defined functions 2
User defined function 5
Multiple User Defined Categories in Insert Function Form 2
Editing user defined functions 5
Any way to use "standard" Excel functions inside VBA functions 4
User Defined Function Help 3
excel spreadsheet functions written in vba 1

Top