Sub or function not defined
I would like to add some VBA functionality to a workbook in order to set a
default value for a cell named Month and another named Year. I've opened
the visual basic editor and added some code like the following:
Function GetMonth()
GetMonth = Month(Date)
End Function
Me!Month = GetMonth()
When I try to run these functions I get an error message "Sub or function
not defined". Are there other steps needed to activate visual basic in this
workbook?
Also, can named cells be referred to as Me as in the above example?
Bill
|