Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Office 2003 on Windows XP.
Suppose you have a custom public function which requires certain arguments. Suppose further that one of those arguments could be one of three choices. When you call the function and open the parentheses you see the listed arguments. Is it also possible to show the three possible choices for the one argument? Is so, could someone please illustrate how to do this? See example function below: Public Function CalculateValue(argItem1, argItem2, argType) as Long If argType = "Normal" then ... If argType = "Modified" then ... If argType = "None" then ... End Function When I'm entering a call to the function as in: Call CalculateValue(lngValue1, lngValue2, ...), when I get to the point where I need to enter the "argType" I want to see what my options are (i.e. Normal, Modified, or None). Kind of like auto-sensing. Can this be done? If so, how? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In the Options window how to create new custom lists | Excel Discussion (Misc queries) | |||
Custom Filtering more than 2 options | Excel Discussion (Misc queries) | |||
Tools Options Custom Lists | Excel Discussion (Misc queries) | |||
options custom list | Excel Worksheet Functions | |||
Autofilters-Remove (Top 10...) and (Custom) options from the drop- | Excel Worksheet Functions |