Friday 25 October 2013

Excel macro to get the month name of given date

Sub getMonthName()

'Print current month name
MsgBox MonthName(Month(Now))

'To print month name of any given date you can use below macro code
MsgBox MonthName(Month("09-jan-1988"))

End Sub


What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.

No comments:

Post a Comment

Popular Posts

Search This Blog