Thread
:
referring to increasing VBA variable name in loop
View Single Post
#
3
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
referring to increasing VBA variable name in loop
I'd use an array:
Dim Phrase(1 to 30) as string
phrase(1) = "what you want1"
....
Phrase(30) = "what you want30"
Then you could use:
Dim iCtr as long
....
for ictr = lbound(phrase) to ubound(phrase)
xl.speech.speak phrase(ictr)
next ictr
wrote:
I am using VBA to put together some phrases to be spoken with the text
to speech feature in excel.
What I've got is a list of string variables,
Phrase1
Phrase2
Phrase3
...
Phrase30
which are set equal to different words or phrases such as
Phrase1 = "Hello"
I can hard-code a variable name into the speech code such as:
XL.Speech.Speak Phrase1
this will successfully speak the string assigned to Phrase1.
What Im having trouble with is referring to the Phrase1-30 variables
in a for loop, something like
for i = 1 to 30
xl.speech.speak phrase & i
next
This code doesn't produce any speech, I'm assuming because the
variable name isn't being passed as intended. How can I refer to
variables within a loop, when the loop # (i) is part of the variable
name?
Thanks.
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson