I think I have a solution for what you want to do, but first a "lesson" on
terminology as the terms you used in your question confused me as to what
you actually want. The "dimension" of an array is how many numbers there are
in the comma separated list between the parentheses. For example...
Dim DataArray(4, 1) As ???
declares a two-dimensional array whereas...
Dim DataArray(4, 1, 7, 2) As ???
declares a four-dimensional array; and so on. When using the array in code,
each of the numbers in the parentheses are called the Index for that
dimension (and they must be numbers). Specifying an index value for each
dimension references a single element in the array. So, the reason I was
confused by your question is that there is no order to these elements in an
array... there is no way to have a "Dimension 1" be an anything... the first
dimension in an array is just the index value specified in the first number
position in the array's "argument" list, the second dimension is just the
index value specified in the second number position in the array's
"argument" list and so on through whatever number of dimensions there are.
Now, if I understand where your question is driving at at-all, I think you
may want an array of Type objects instead of a just a simple array. The
syntax in use will be a little different than in a normal array, but I think
it provides the functionality you ultimately want. I'm going to give you a
made up example to show how to declare a Type object and then show you how
to use it (but you may want to lookup "Type Statement" in the VB help files
for more information on it).
This establishes a Type object that will be used to identify employees in a
company ...
Type EmployeeRecords
ID As Integer
Name As String
Address As String
Phone As Long
StartDate As Date
End Type
The Type Statement starts with the Type keyword and it is followed by the
name you want to give to the structure that follows below it (here, I have
chosen to call it EmployeeRecords) and ends with the End Type statement.
Between those two statements are placed any number of "members" of the
Type... these are declared exactly like Dim statements, but without the Dim
keyword in front of them. The above Type..End Type block is placed in the
(General)(Declarations) section of whatever module you place it in... it is
never placed inside any of your Subs or Functions themselves. In order to
use a Type, you have to declare a variable of for it. You would do that like
this (where I have chosen to name this variable Employee)...
Dim Employee As EmployeeRecords
or like this if you want to create a fixed array of them (10 array elements
in this example)...
Dim Employee(1 To 10) As EmployeeRecords
or you could make a dynamic array of them like this...
Dim Employee() As EmployeeRecords
and provide the number of dimensions via a ReDim statement within your code
when you have determined how may elements of your Employee array you will
need.
Okay, that takes care of creating the Type object. To use it, you refer to
the members of the Type using dot notation. For example...
Employee.ID = 123
Employee.Name = "John Jones"
etc.
If you Dim'med Employee as an array, then you would need to provide an index
value for the array...
Employee(1).ID = 123
Employee(1).Name = "Jone Jones"
etc.
Employee(2).ID = 456
Employee(2).Name = "Jane Doe"
etc.
Of course, you could iterate through the array via a For..Next loop (just
like any other array) if needed.
Okay, as I said, I **think** this kind of structure may be what you were
looking for in your original question.
