MonthName
Using the MONTHNAME Function
In this tutorial you will learn how to use the MONTHNAME Function.
The MONTHNAME function returns a string indicating the specified month.
=MONTHNAME( month, abbreviate )
month a numeric designation for the month of the year.
date is a Boolean value to determine whether or not to abbreviate. (Default) False
The result is November.
 FORM
In a Form you could set the Default Value of a Textbox to
=MONTHNAME(11)
 VBA
In a Form add a TEXTBOX control and rename it "txtMonthName", then you could add the following in the Load Event.
Private Sub Form_Load()
txtMonthName = MonthName(11)
End Sub
Course
Want to learn more? Request this via the contact form.
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
