What is an equivalent function for the EXCEL "INDIRECT" function but in Visual Basic ...?

Question

... or a workaround. This is the problem solved if the hypothetical function were the same name in Basic. I want to extract the keyed value in 5 objects in a form using a loop. The objects are :

Text1
Text2
Text3
Text4
Text5

Code would be (if indirect function existed) :
For a=1 to 5
b="Text"+str(a)+".text"
c(a)=INDIRECT(b) '***this would gran the value inText1.text on the first round***
Next a

Help very appreciated.

Answer 1

for excel functions that do not have vba equivalent, you can use application. prefix eg application.indirect etc etc.

Answer 2

Morality is mostly a basic instinct to not do things to others that we wouldn't want done to ourselves. We can empathize with our potential victims. There does seem to be a point at which mental health degrades beyond the ability to feel and understand this empathy. That would be what I'd consider "innocent by reason of insanity". However, people with less impared brain function might have a harder time making moral decisions, but can nonetheless and choose not to. These are criminals. I think some counseling would help most criminals, yes, but it isn't necessary for them to make better decisions. It would just help a lot. Being able to function as a normal human does depend on proper brain function, however, there is a spectrum of mental capacity, not an on / off switch.