1,105,417 Community Members

Declaring multidimensional array in VBA

Member Avatar
Ved_TheOne
Newbie Poster
16 posts since Mar 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi, i m currently working in autoCAD

Can anyone provide me syntax for multidimensional array in VB6.0 for VBA

whn i declare by following syntax it gives me error

dim arra(,) as Long

Any help would be appreciated

I want to declare a multidemsional array row is of long data type
while columns are variant

Member Avatar
aktharshaik
Posting Whiz
318 posts since Aug 2008
Reputation Points: 16 [?]
Q&As Helped to Solve: 41 [?]
Skill Endorsements: 0 [?]
 
0
 

U can use the same syntax

'If u want to store diff values in different 
'columns use variant else use ur required
'datatype
Dim arr(5,5) as Variant

'If at any instance you want to resize
'ur array use the following syntax
'Preserve  keyword is optional
'It will help you retain the earlier values
Redim Preserve arr(10,7) as Variant

This is the reference from MSDN below
Used atprocedure level to reallocate storage space for dynamic arrayvariables.

Syntax

ReDim [Preserve] varname(subscripts) [As type] [, varname(subscripts) [As type]] . . .

The ReDim statement syntax has these parts:

Part Description
Preserve Optional.Keyword used to preserve the data in an existingarray when you change the size of the last dimension.
varname Required. Name of the variable; follows standard variable naming conventions.
subscripts Required. Dimensions of an array variable; up to 60 multiple dimensions may be declared. The subscriptsargument uses the following syntax:
[lower To] upper [,[lower To] upper] . . .

When not explicitly stated in lower, the lower bound of an array is controlled by the Option Base statement. The lower bound is zero if no Option Base statement is present.

type Optional.Data type of the variable; may beByte,Boolean,Integer,Long,Currency,Single,Double,Decimal (not currently supported),Date,String (for variable-length strings), String * length (for fixed-length strings),Object,Variant, auser-defined type, or anobject type. Use a separate As type clause for each variable being defined. For a Variant containing an array, type describes the type of each element of the array, but doesn't change the Variant to some other type.


Remarks

The ReDimstatement is used to size or resize a dynamic array that has already been formally declared using a Private, Public, or Dim statement with empty parentheses (without dimension subscripts).

You can use the ReDim statement repeatedly to change the number of elements and dimensions in an array. However, you can't declare an array of one data type and later use ReDim to change the array to another data type, unless the array is contained in a Variant. If the array is contained in a Variant, the type of the elements can be changed using an As type clause, unless you’re using the Preserve keyword, in which case, no changes of data type are permitted.

If you use the Preserve keyword, you can resize only the last array dimension and you can't change the number of dimensions at all. For example, if your array has only one dimension, you can resize that dimension because it is the last and only dimension. However, if your array has two or more dimensions, you can change the size of only the last dimension and still preserve the contents of the array. The following example shows how you can increase the size of the last dimension of a dynamic array without erasing any existing data contained in the array.

ReDim X(10, 10, 10)
. . .
ReDim Preserve X(10, 10, 15)

Similarly, when you use Preserve, you can change the size of the array only by changing the upper bound; changing the lower bound causes an error.

If you make an array smaller than it was, data in the eliminated elements will be lost. If you pass an array to a procedure by reference, you can't redimension the array within the procedure.

When variables are initialized, a numeric variable is initialized to 0, a variable-length string is initialized to a zero-length string (""), and a fixed-length string is filled with zeros. Variant variables are initialized toEmpty. Each element of a user-defined type variable is initialized as if it were a separate variable. A variable that refers to an object must be assigned an existing object using the Set statement before it can be used. Until it is assigned an object, the declaredobject variable has the special value Nothing, which indicates that it doesn't refer to any particular instance of an object.

Caution The ReDim statement acts as a declarative statement if the variable it declares doesn't exist atmodule level orprocedure level. If another variable with the same name is created later, even in a widerscope, ReDim will refer to the later variable and won't necessarily cause a compilation error, even if Option Explicit is in effect. To avoid such conflicts, ReDim should not be used as a declarative statement, but simply for redimensioning arrays.

Note To resize an array contained in a Variant, you must explicitly declare the Variant variable before attempting to resize its array.

Member Avatar
aktharshaik
Posting Whiz
318 posts since Aug 2008
Reputation Points: 16 [?]
Q&As Helped to Solve: 41 [?]
Skill Endorsements: 0 [?]
 
0
 

CHECK THE DOCUMENTATION IN WORD FORMAT.

Regards

Shaik Akthar

Attachments REDIM.doc (40KB)
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article