Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct function / VB user defined function | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
Max of a defined function | Excel Worksheet Functions | |||
User Defined Function | Excel Discussion (Misc queries) | |||
User-defined function | Excel Worksheet Functions |