Strange variable declarations

S

Steven Revell

Hi All,

I have come across the following variable declarations in
a program i have inherited. I was wondering what the $
sign is there for.

Dim Row$
Dim EVT$
Dim Paste$
Dim Results$

Values can be assigned as normal and my first though is
that it changes the values to text strings automatically.
I just though i'd ask and see if this was the case.

Cheers,
Steven
 
P

pancho

It is known as "type-declaration character" and is same as
declaring the variable with the following types:
$ String
@ Currency
# Double
% Integer
& Long
! Single


Francisco Mariscal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
only 1 time declaring variables 5
Some trouble assigning a string to a variable 22
Explicit declaration of variables 1
Declaring Variables Twice? 2
VBA Assigning cell value to variable giving runtime error 3
Declaring an array variable 3
Dynamically declare and populate variables 6

Top