Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referring to increasing VBA variable name in loop
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to a variable file name | Excel Discussion (Misc queries) | |||
Referring to multiple worksheets via a variable | Excel Programming | |||
Referring to a Worksheet with a variable | Excel Programming | |||
Increasing a range in a loop | Excel Programming | |||
Referring to a worksheet using variable | Excel Programming |