MonthName Function [VBA]

The MonthName function returns the localized month name of a specified month number.

warning

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.


Syntax:


        MonthName(Month as Integer [,Abbreviate as Boolean])
    

Return value:

String

Parameters:

Month: Value from 1 to 12, January to December, whose localized month name need to be returned.

Abbreviate: Optional. A Boolean value that indicates if the month name is to be abbreviated.

Error codes:

5 แž€แžถแžšโ€‹แž แŸ…โ€‹แž”แŸ‚แž”แž”แž‘โ€‹แž˜แžทแž“โ€‹แžแŸ’แžšแžนแž˜แžแŸ’แžšแžผแžœ

Example:


        REM  *****  BASIC  *****
        Option VBASupport 1
        Sub Example_MonthName
         Dim mBirthday as Integer
         mBirthday = 1
         print mBirthday &" "& MonthName(mBirthday,False)
        End Sub