Accessing the Excel function TODAY() ...

Question

Hi,

I'm trying to use an Excel function called TODAY(). I wish to use it simple macro but it doesn't appear to be working. Here is my example:

Sub Test_Display_My_Date()

MsgBox Text(TODAY(), "mm, " - " dd, " - " yy")

End Sub

This macro returns a compile error: "Sub or Function not defined". Can someone explain what I am doing wrong?

Thanks,
Greg

Answer 1

Thank you! This is just what I needed! :-)

Answer 2

TODAY() is an Excel worksheet function, but not a VBA function. The VBA equivalent is Date.

Similarly, TEXT is Excel only. The VBA equivalent is Format.

Sub Test_Display_My_Date()
MsgBox Format(Date, "mm - dd - yy")
End Sub