why add a dollar sign to a vba function

Asked Jan 05 '21 at 14:55

Active Jan 05 '21 at 14:55

Viewed 212 times

In another question I see a dollar sign at the end of a excel vba function. I cannot find anywhere what is the impact of this syntax.

How to prevent Excel to use the OS regional settings for date patterns in formulas

Public Function GetFormat$(Cell As Range, Optional ByVal UseLocal As Boolean)
    If UseLocal Then
        GetFormat = Cell.NumberFormatLocal
    Else
        GetFormat = Cell.NumberFormat
    End If
End Function

I checked, it works, but why ?

asked Jan 05 '21 at 14:55

Sam73

As I understand it, it forces the return as a string. – Scott Craner Jan 05 '21 at 14:59
https://stackoverflow.com/questions/3389444/what-does-the-symbol-do-in-vba – spikey_richie Jan 05 '21 at 15:25
thats it, thanks for the link and the answer. – Sam73 Jan 05 '21 at 23:04

why add a dollar sign to a vba function

0 Answers0