Probably a simple answer

[od_gwyn]

I'm making a module that returns the Name of todays Month, all i want to know is how to return this value. i.e. what do i put in the module so that when it is run, a value is returned.

e.g. TextBox.Text = TodaysMonth()

Sub TodaysMonth()
MyDate = Now() 'Returns todays month name
MonthNo = Month(MyDate)
MyMonthName = MonthName(MonthNo)
End Sub

I want the text box to show 'MyMonthName'

 

[Mile-O]

Even easier:

=Format(Date(), "mmmm")

 

[Mile-O]

For future reference though - subs don't return values; functions do.


i.e

Function TodaysMonth()
    TodaysMonth = Format(Date(), "mmmm")
End Function

 

[Rich]

Even easier:

=Format(Date(), "mmmm")

and even easier, easier is to just set the display format to MMMM and set the control source to =Date()

 

[Mile-O]

True. True.

 

[od_gwyn]

cheers very much like