VBA how to create variable name containing variable

Question

I have a macro with a variable number of players (1 and up). These players should be Player1, Player2, etc. How can I create variable names "on the fly"?

The best I can think of is something like this: a=a+1 Dim Player&(a)

Any reason for not using an array? (Dim player(1 To 10) As String: player(1) = "test1", player(2) = "test2",...) — paul bica
– paul bica, Commented Aug 15, 2015 at 18:26

Anton Malyshev · Accepted Answer · 2015-08-15 18:25:23Z

2

Use Dictionary instead (treat keys as variable names): https://support.microsoft.com/en-us/kb/187234

answered Aug 15, 2015 at 18:25

Anton Malyshev

8,9442 gold badges33 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

VBA how to create variable name containing variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related