Converting months as # to Text Month

G

Guest

Programmatically, how would I convert the month from 1-12 to January -
December. Let's assume my variable for month is called MONTH.

Thanks
 
G

Guest

This should be close...

Dim intMonth As Integer

intMonth = 5
MsgBox Format(DateSerial(2000, intMonth, 1), "mmm")
 
L

Les Stout

Hi Barb,

you could try:-

Sub Month()

Dim Mnth As String
Mnth = Format(Date, "mmmm")
MsgBox "This month is : " & Mnth

End Sub


Les Stout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
please help me format this date to Month and Year 4
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Mapping strings to integers 5
Array Variable for Month Names 5
Finding month in mm/dd/yyyy format 5
Identify last date of a specific month 8
Looking formula that gives total of remaining months 6

Top