Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
You can't have the editor display the possible choices for an
argument unless the argument's type is Long. In this case, you use an Enum type. E.g., Public Enum MyType Modified = 0 Normal = 1 None = 2 End Enum Function MyFunction(Arg1 As MyType) ' your code here End Function With enums, you don't have to supply the actual values, as show in my example. If you omit the values, the first value will be zero, and values will be sequentail. Note that enums are supported in Excel 2000 at later. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "quartz" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
Only if you use the function wizard to insert the function and supply help
for the arguments of a function. This can't be done with VBA alone. You can use Larent Longre's addin free addin to assist. http://xcell05.free.fr/ There is no option for it to work like autosense, however. -- Regards, Tom Ogilvy "quartz" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
My comments are related to using a custom function in a worksheet.
I believe Chip's relate to using it in the VBE. But, he may know something I don't. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Only if you use the function wizard to insert the function and supply help for the arguments of a function. This can't be done with VBA alone. You can use Larent Longre's addin free addin to assist. http://xcell05.free.fr/ There is no option for it to work like autosense, however. -- Regards, Tom Ogilvy "quartz" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
Thanks Chip and Tom.
Sorry, I should have made it clearer Tom, I was looking for the VBE method. Thanks for your reply. "Tom Ogilvy" wrote: My comments are related to using a custom function in a worksheet. I believe Chip's relate to using it in the VBE. But, he may know something I don't. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Only if you use the function wizard to insert the function and supply help for the arguments of a function. This can't be done with VBA alone. You can use Larent Longre's addin free addin to assist. http://xcell05.free.fr/ There is no option for it to work like autosense, however. -- Regards, Tom Ogilvy "quartz" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show what options are in custom function?
You checks would then be against the enum types defined:
Public Function CalculateValue(argItem1, argItem2, argType As MyType) As Long Dim sMsg As String If argType = Modified Then sMsg = "Modified" ElseIf argType = Normal Then sMsg = "Normal" ElseIf argType = None Then sMsg = "None" Else sMsg = "Not Valid" End If End Function Without quotes. -- Regards, Tom Ogilvy "quartz" wrote in message ... Thanks Chip and Tom. Sorry, I should have made it clearer Tom, I was looking for the VBE method. Thanks for your reply. "Tom Ogilvy" wrote: My comments are related to using a custom function in a worksheet. I believe Chip's relate to using it in the VBE. But, he may know something I don't. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Only if you use the function wizard to insert the function and supply help for the arguments of a function. This can't be done with VBA alone. You can use Larent Longre's addin free addin to assist. http://xcell05.free.fr/ There is no option for it to work like autosense, however. -- Regards, Tom Ogilvy "quartz" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pls clarify how to call an Addin from another addin using VBA
I Need to call an addin from another addin and also I need to pass arguments
to that addin. Is it possible. If so pls give me suggestions. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pls clarify how to call an Addin from another addin using VBA
Do you mean a macro within the addin? That would be
.... with parameters Application.Run "myAddin.xla!test_msgbox", 4, 8 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Prabakar" wrote in message ... I Need to call an addin from another addin and also I need to pass arguments to that addin. Is it possible. If so pls give me suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |