Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions - Input prompts
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions - Input prompts
see:
http://groups.google.com/group/micro...6f0180ce2819d5 -- Gary''s Student - gsnu200756 "Isit Ears" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Functions - Input prompts
Gary:
Google returns "Topic not found" (link broken?). -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions - Edit line prompts and/or help | Excel Programming | |||
User Defined/Custom Input | Excel Discussion (Misc queries) | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
prompts for the user defined functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |