Set Multiple Variables

R

Risky Dave

Hi,

If I have Dim'd a bunch of string variables, is it possible to set them all
to the same value in a single line?

Eg.

Dim sText1
Dim sText2

sText1, sText2 = "" 'this doesn't work!

I actually have about 20 of these variables that I want to set to blank
before working with them, and having the same line 20 times seems to be
rather inefficient.

This is in Office 2003, if that makes a difference.

TIA

Dave
 
M

Mike H

Hi,

You can't reset a group of individual variables in one go, it would have to
be done one at a time.

Mike
 
N

Nigel

You can dim multiple variables on one line

Dim sText1 as String, sText2 as String

or why not consider using an array e.g

Dim sText(1 To 20) As String

You can then set and read each by reference the array index

sText(1) = "My Value"
 
R

Risky Dave

Darn! (or words to that effect)

Thanks anyway

Mike H said:
Hi,

You can't reset a group of individual variables in one go, it would have to
be done one at a time.

Mike
Click to expand...
 
Top