VBA - Formatting date as string?

[BobBeerbower]

I get a compile error: Wrong number of arguments or invalid property assignment error when I try to convert todays date to a string using the following code. I'm probably overlooking something obvious but I cannot figure out what it might be.

Public Sub LooperDrive()

Dim sDate
    sDate = Format(Date, "mm/dd/yyyy")

End Sub

 

[Joe4]

Welcome to the Board!

Works fine for me. Are you sure the error is on this procedure?
I would recommend declaring your variable as String, though:

Public Sub LooperDrive()

    Dim sDate As String
    sDate = Format(Date, "mm/dd/yyyy")
    MsgBox sDate

End Sub