devxlogo

Creating 2 Dimensional Array

Creating 2 Dimensional Array

Question:
I am trying to design a telephone directory and am unable to set the 2 dimensional arrayas an unknown number. How do I do this?

Answer:
The best way to do this is to set the second dimension (which can be changed dynamically) to something like 1 to start, and then as you need to, use ReDim with the Preserve option to enlarge the array as you are filling it.Unfortunately, making the second dimension grow without being able to do the same for the first leads to difficulties if all your data come in pairs.If you actually need to reference two different variables that have to stay together (e.g. a name and a phone number) you can either use two different arrays that you Redim the same each time or you can read your records (name and phone number) into a listbox, separating them by a parsable character such as a tab, a tilde (the squiggly line that’s usually over the reverse single quote) or some other character that’s not likely to be used in the data itself.

See also  What Are International Payments, And How Do They Work?
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist