<div>
why not use an array?<br />
<br />
Dim numVars As Integer<br />
Dim i As Integer<br />
<br />
numVars = 40<br />
<br />
Dim DS() As Single<br />
ReDim DS(1 To numVars)<br />
<br />
For i = 1 To UBound(DS)<br />
&nbsp; &nbsp; DS(i) = Rnd * 10<br />
Next
</div>


why not use an array?

Dim numVars As Integer
Dim i As Integer

numVars = 40

Dim DS() As Single
ReDim DS(1 To numVars)

For i = 1 To UBound(DS)
    DS(i) = Rnd * 10
Next

<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
- answered by ameba<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
twalgrave<br />
Cleanup Volunteer<br />

</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- answered by ameba
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

twalgrave
Cleanup Volunteer


<div>
per recommendation<br />
<br />
SpideyMod<br />
Community Support Moderator @Experts Exchange
</div>


per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

<div>
<div class="content wysiwyg-content">
I need code to create multiple variables from the subroutine. &nbsp;I need to create DS1 - DS40. &nbsp;Those need to be the variable names, but I'd like the program to create them without having to type them all in. &nbsp;If I know how to do this, I can apply it to multiple programs.<br />
<br />
For T = 1 to 40<br />
<br />
DS(T) = rnd *10<br />
<br />
Next T<br />
<br />
I need the program to create variables based on a counter. &nbsp;These variables have to be declared as single. &nbsp;I would like the simplest way to do this.
</div>
</div>


I need code to create multiple variables from the subroutine.  I need to create DS1 - DS40.  Those need to be the variable names, but I'd like the program to create them without having to type them all in.  If I know how to do this, I can apply it to multiple programs.

For T = 1 to 40

DS(T) = rnd *10

Next T

I need the program to create variables based on a counter.  These variables have to be declared as single.  I would like the simplest way to do this.

Create a variable within the subroutine

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.