| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
User Defined Functions
I'm new to UDFs and want to be able to call one from within a spreadsheet.
I have hit Alt+F11 and input the code within the empty code window relating to the workbook where I want to be able to access the UDF, but when I then try and call the UDF in the workbook, I get an #NAME? error. Can anyone tell me where I'm going wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User Defined Functions
User Defined Function needs to be stored in a module - so insert a
module, then move your UDF into it - should resolve the problem. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User Defined Functions
Many thanks, Aidan
" wrote: User Defined Function needs to be stored in a module - so insert a module, then move your UDF into it - should resolve the problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user form question: text box to display result | Excel Worksheet Functions | |||
| User defined charts | Charts and Charting in Excel | |||
| Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
| Excel user defined functions. | Excel Worksheet Functions | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
Linear Mode
