I tried "DIM A$ AS STRING" which produced an error.

1) How do you initalize/define a string variable?

2) What is the proper way to initalize all other types of variables?

3) Does VBA really restrict things to integers, bytes, boolean expressions,
etc, or are they still variants?

Thanks in advance,

Christmas May

Here is everything you ever wanted to know about delcaring variables...

http://www.cpearson.com/excel/variables.htm

You will run into difficulty because of the use of the $ sign...

dim a as string
or
dim a$

Either of which will declare a string.
--
HTH...

Jim Thomlinson


"Christmas May" wrote:

I tried "DIM A$ AS STRING" which produced an error.

1) How do you initalize/define a string variable?

2) What is the proper way to initalize all other types of variables?

3) Does VBA really restrict things to integers, bytes, boolean expressions,
etc, or are they still variants?

Thanks in advance,

Christmas May

Mr. Jim Thomlinson,

1) Thanks for the link!

2) Thanks for the assistance with string variables. (Darn Quickbasic 4.0
habits)

3) I'm considering this matter closed, unless someone else wishes to add
commentary.

Sincerely,

Christmas May



"Jim Thomlinson" wrote:

Here is everything you ever wanted to know about delcaring variables...

http://www.cpearson.com/excel/variables.htm

You will run into difficulty because of the use of the $ sign...

dim a as string
or
dim a$

Either of which will declare a string.
--
HTH...

Jim Thomlinson


"Christmas May" wrote:

I tried "DIM A$ AS STRING" which produced an error.

1) How do you initalize/define a string variable?

2) What is the proper way to initalize all other types of variables?

3) Does VBA really restrict things to integers, bytes, boolean expressions,
etc, or are they still variants?

Thanks in advance,

Christmas May