Variable number of arguments in ParamArray ArgList()

Posted by Excel VBA guy on Stack Overflow See other posts from Stack Overflow or by Excel VBA guy
Published on 2009-06-04T08:31:06Z Indexed on 2010/04/14 20:53 UTC
Read the original article Hit count: 278

Filed under:

excel-vba

|

paramarray

|

vba

If I want to pass a number of values for the ParamArray arglist via an array, how do I do it? From what I've read so far, on VBA, it appears that I need to explicitly list the values that I want to pass. But what if there are potentially different numbers of values to pass, so I do not know in advance how many I'll want to pass to the function? Is there not some way of using an array (a one-dimensional array) with a variable dimension?

© Stack Overflow or respective owner

Related posts about excel-vba

Autofilter with multi-columns in Excel VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to use VBA to filter some information in excel. As I have an excel with 20 columns, now want to use AutoFilter function to search in some columns if it contains one value (Ex: ID010). what i want is it'll display all rows that have at least one column contains ID010. Currently, i use the below… >>> More
Calling oracle stored procedure from Excel - VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to execute an Oracle stored procedure from vba (Excel) with around 38 input parameters. The stored procedure will insert some values in the destination table once that is executed. When it is executed through VBA the number of fields which is inserted is less than when it… >>> More
In Excel, VBA - How can we lock resizing of a rectangle

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an excel sheet that contains two rectangles and text in other cells. I need to allow users to only edit the text in the rectangle. They should not be able to change the size of the object. Applying lock on the rectangle locks the object as well as the text. Does anyone know how I can achieve… >>> More
Using Excel VBA to capture standard toolbar use

as seen on Super User - Search for 'Super User'
I am looking for a way to capture a click on a standard toolbar tool in Excel with VBA. The primary need is to capture any Copy, Cut, and Paste request by the user. I can capture the hot keys for these functions, but I can't find a way to capture the same functions when the user clicks on the icon… >>> More
Excel VBA and InternetExplorer causing errors on website

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some "clever" users who have written an excel spreadsheet that automates some of their tasks on our intranet/timesheet. It seems as if the instance of Internet Explorer that is created is not doing everything I expect a browser to do, e.g. set cookies. Is there a way to detect if a user is… >>> More

Related posts about paramarray

Delegates and ParamArray - Workaround Suggestions?

as seen on Stack Overflow - Search for 'Stack Overflow'
Some predefined methods contain a ParamArray in their signature. Delegates, however, cannot contain a ParamArray in their signature. Main question: Assume you wish to create a delegation mechanism for a specific method which requires a ParamArray. How would you work around this constraint? "Bonus"… >>> More
Variable number of arguments in ParamArray ArgList()

as seen on Stack Overflow - Search for 'Stack Overflow'
If I want to pass a number of values for the ParamArray arglist via an array, how do I do it? From what I've read so far, on VBA, it appears that I need to explicitly list the values that I want to pass. But what if there are potentially different numbers of values to pass, so I do not know in advance… >>> More
How to use reflection to call a method and pass parameters whose types are unknown at compile time?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to call methods of a class dynamically with parameter values that are "parsed" from a string input. For example: I'd like to call the following program with these commands: c:myprog.exe MethodA System.Int32 777 c:myprog.exe MethodA System.float 23.17 c:myprog.exe MethodB System.Int32&… >>> More
ie8 breaks with asp.net ajax

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, When using asp.net ajax (scriptmanager, timer, updatepanel) with ie8, after certain time (~3h) IE breaks with null object, constructor, or paramArray (depending on the asp.net code). Even with the simplest timer (no ajax, no updatepanel) ie8 still breaks. On every other browser it works… >>> More
Visual Basic: passing arrays between Functions???

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a visual basic function with a ParamArray output, and I want that output to be available to another function, without having to put it on a worksheet just to pick it into that second function. Is there a way to transfer arrays between functions in visual basic? Thanks in advance for your… >>> More