month name – Useful code

VBA – Convert Month Name to Number and Vice Versa

Posted on May 29, 2020 by

Convert number to name – [3 -> March] Converting month number to name in VBA is actually coming out of the box with the MonthName() function, which is built-in the stanard VBA library:

Sub MonthNameExample()
    
    Dim i As Long
    For i = 1 To 12
        Debug.Print MonthName(i)
        Debug.Print Format(MonthName(i, True))
    Next
    
End Sub

Sub MonthNameExample()

Dim i As Long

For i = 1 To 12

Debug.Print MonthName(i)

Debug.Print Format(MonthName(i, True))

End Sub

The result is not flabbergasting, but…

Tag: month name

VBA – Convert Month Name to Number and Vice Versa