Dim Msg
declares Msg as a variant.

It can hold anything--numbers, text, objects...

Dim Msg$
is the same as
dim Msg as String

That $ sign is one of the several type declaration character shortcuts. (I find
them difficult to remember, so I don't use them.)

# = Double
% = Integer
& = Long
@ = Currency
! = single
$ = string



Steph wrote:

Hi. I'm getting familiar with code that someone else wrote, and ran across
something I have never seen before. What is the difference between:
Dim Msg
Dim Msg$
What does the $ do? Thanks!

--

Dave Peterson