you can also do it like this
VB Code:
  1. Dim LastMonth
  2. LastMonth = Format(DateAdd("m", -1, Format(Now, "mm/dd/yy")), "mmmm")