MonthName Function [VBA]

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

แƒ’แƒแƒ•แƒ แƒ—แƒฎแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

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


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

Return value:



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:

D'oh! You found a bug (text/sbasic/shared/00000003.xhp#err5 not found).


REM  *****  BASIC  *****

Option VBASupport 1

Sub Example_MonthName

 Dim mBirthday as Integer

 mBirthday = 1

 print mBirthday &" "& MonthName(mBirthday,False)

End Sub