MonthName Help Example Problem

[Guest]

I cut and pasted the following from the HELP into the form load event of a
new form and I get an error stating that MonthName is a namespace and can not
be used as shown. What's wrong?

Dim MyMonth As Integer
Dim Name As String
MyMonth = 4
Name = MonthName(MyMonth, True) ' "True" returns an abbreviated name.
MsgBox(Name) ' Name contains "Apr".

 

[Herfried K. Wagner [MVP]]

I cut and pasted the following from the HELP into the form load event of a
new form and I get an error stating that MonthName is a namespace and can
not
be used as shown. What's wrong?

Dim MyMonth As Integer
Dim Name As String
MyMonth = 4
Name = MonthName(MyMonth, True) ' "True" returns an abbreviated
name.
MsgBox(Name) ' Name contains "Apr".

Qualify the function's name with the module containing it
('DateAndTime.MonthName').

 

[Guest]

i think you have the problem in another place... i try the code and works
just fine!

 

[Guest]

I found out what the probelm was. When I created the project I named it
MonthName instead of MonthNameDemo. SO the project name and the function were
named the same.

 

[Herfried K. Wagner [MVP]]

I found out what the probelm was. When I created the project I named it
MonthName instead of MonthNameDemo. SO the project name and the function
were
named the same.

ACK. By default the project's root namespace has the name of the project.