VBA : How to define a large set of string variables?

Question

I am trying (in VBA) to define a large number of string variables. The brute force would be :

Dim Port1 as String Dim Port2 as String etc…

Unpleasant for say 100 variables. There must be a more intelligent solution. I have tried :

Dim n As Integer For n = 1 To 100 Dim "Port" & n as String Next n

and variations of it without success. I would greatly appreciate if someone could point me in the right direction or share an example.

Look into arrays, it will allow you to load it up with a loop. — Scott Craner
– Scott Craner, Commented Feb 10, 2016 at 17:52

AndASM · Accepted Answer · 2016-02-10 18:02:35Z

7

Arrays do exactly this! See this example:

Dim Port(1 to 100) As String
Dim i As Long

Port(1) = "String"
For i = 2 to 100
    Port(i) = "String " & i
Next i

It sets Port(1), the first array element to the word "String". Everything else Port(2) and on, contain "String 2", "String 3", etc. Up to Port(100).

I hope that helps!

answered Feb 10, 2016 at 18:02

AndASM

10.7k1 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Studix Over a year ago

Thank you AndASM, I will try and it sounds the right way to go. I ignored there were arrays in VBA (very stupid of me…!!!) Thanks.

Collectives™ on Stack Overflow

VBA : How to define a large set of string variables?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related