Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
I am missing something fundamental in creating functions in Excel. Does
somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
On Mon, 3 Sep 2007 05:08:01 -0700, Creating Functions in Excel <Creating
Functions in wrote: I am missing something fundamental in creating functions in Excel. Does somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim Make sure your functions have unique names. (You can also use fully-qualified names, but this is a PITA). Make sure they are in a regular module, and not a workbook or worksheet module. --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
On Mon, 3 Sep 2007 05:56:00 -0700, Creating Functions in Excel
m wrote: Hi, Thanks. Sorry if I sound dim, but how do I insert functions into standard modules rather than workbook or worksheet modules? Jim After opening the VB Editor, and selecting your project, you select Insert/Module and enter your code into the window that opens. In the subtree under your project, you will see something like: VBAProject(Book2) Microsoft Excel Objects Sheet1 Sheet2 ThisWorkbook Modules Module1 Your code should be in "Module1" --ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
Generally speaking, the best way to make functions (UDFs) "findable" from the
VBE environment and "reachable" from the worksheet is to: 1. Insert them in standard modules 2. Declare them Public Public Function bumpit(i As Integer) As Integer bumpit = i + 1 End Function -- Gary''s Student - gsnu200742 "Creating Functions in Excel" wrote: I am missing something fundamental in creating functions in Excel. Does somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
Hi,
Thanks. Sorry if I sound dim, but how do I insert functions into standard modules rather than workbook or worksheet modules? Jim "Gary''s Student" wrote: Generally speaking, the best way to make functions (UDFs) "findable" from the VBE environment and "reachable" from the worksheet is to: 1. Insert them in standard modules 2. Declare them Public Public Function bumpit(i As Integer) As Integer bumpit = i + 1 End Function -- Gary''s Student - gsnu200742 "Creating Functions in Excel" wrote: I am missing something fundamental in creating functions in Excel. Does somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
User Defined Functions (UDFs) are very easy to install and use:
1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the UDF will be saved with it. To remove the UDF: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To use the UDF from Excel: =myfunction(A1) To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200742 "Creating Functions in Excel" wrote: Hi, Thanks. Sorry if I sound dim, but how do I insert functions into standard modules rather than workbook or worksheet modules? Jim "Gary''s Student" wrote: Generally speaking, the best way to make functions (UDFs) "findable" from the VBE environment and "reachable" from the worksheet is to: 1. Insert them in standard modules 2. Declare them Public Public Function bumpit(i As Integer) As Integer bumpit = i + 1 End Function -- Gary''s Student - gsnu200742 "Creating Functions in Excel" wrote: I am missing something fundamental in creating functions in Excel. Does somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating functions
Jim,
See http://www.cpearson.com/excel/Writin...ionsInVBA.aspx for a step-by-step guide to writing User Defined Functions in VBA. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Creating Functions in Excel" <Creating Functions in wrote in message ... I am missing something fundamental in creating functions in Excel. Does somebody have step by step, comprehensive instructions? At this point, I somehow have a simple function that is recognized and returns a 0 value, but does not appear in the VB Editor or in the list of functions. Two other simple functions - same as the first with slightly different names - appear in the list of functions and in the VB Editor, but are not recognized when I insert the names into the corresponding spread sheet. Help would be appreciated, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating VBA Functions When Creating Spreadsheet Via VBA? | Excel Programming | |||
Creating functions | Excel Programming | |||
Creating Functions | Excel Programming | |||
creating new functions | Excel Worksheet Functions | |||
Creating Help within functions | Excel Programming |