As far as I know, it's just for backwards compatibility. Old versions of VBA
(such as Excel Basic and Word Basic) put a dollar at the end of every
string/text function. You don't have to bother putting it in now and many of
the functions have been improved to allow their use on more than just strings.

"Kletcho" wrote:

> What is the significance of some of the VBA functions having a
> counterpart with a $. For example there is the Mid function and also
> the Mid$ function. What is the difference?
>
>