strMonth = CHOOSE(MONTH("04.02.2003"),"January","February","M arch","April"
....)

Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA


"Pedro" schrieb im Newsbeitrag
...
Hi

I have the following code

Dim strDate as Date

strDate="30/06/2003"

I want strMonth to be the same month as the strDate. In this example I
want
the output of strMonth to be June
What code should I write to get it from the strDate?

Regards
Pedro