Topic profile page for User defined function.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: User defined function.
Topic "User defined function" was discussed 0 times on 0 sites in last 3 months
Started 1 day, 1 hour ago (2009-12-22 08:58:00)
by Weeble
I am trying to create a Function that will perform a calculation that will be referenced by other Subs and or Functions. I would like to access data in a table directly from within the Function. Is this possible? I can find nothing that says yea or nay. Thanks.
Started 1 week ago (2009-12-15 14:56:00)
by Henry Stockbridge
Hi, I have created a user defined function that is stored in my personal macro workbook. When I change a value in one of the referenced cells, the result does not recalc. AutoCalc is set to true in Tools --> Options, but I still need to F9 to see the resulting value. (Excel 2003.) Any help you can lend on this is ...
Started 1 week, 4 days ago (2009-12-11 10:56:00)
by Mgibson
Hi, Please help me to solve this user defined function question. I have to solve the equation but i need help and advice on how to put the formula into the module sheet. the question is "Write a USER DEFINED FUNCTION to SOLVE the following equation for L for a given d and T. Name this user defined function FWC. Enter a value of 100.0 for d and 1 for T in ...
Started 3 weeks ago (2009-12-01 18:58:00)
by nik.invincible
find address of home cell in a user defined function I am newbie at excel so this question may seem naive. I am writing a function wherein I need to find the column number of the cell which contains the formula. I used Application.Caller.Column which worked fine. Now when I change the value of any of the precedents of ...
Started 3 weeks, 1 day ago (2009-12-01 03:08:00)
by JohnM[_3_]
I want to create a function to return the gestational age of babies on their date of birth (DOB) with reference to the due date (the estimated date of confinement or EDC). The function I have at the moment is: Function Gest(DOB As Variant, EDC As Variant) As Single 'Returns the gestation in the form x.y where x is the number of completed weeks 'and y is the additional days, which ...
Started 3 weeks, 1 day ago (2009-12-01 03:08:00)
by JohnM[_5_]
I want to create a function to return the gestational age of babies on their date of birth (DOB) with reference to the due date (the estimated date of confinement or EDC). The function I have at the moment is: Function Gest(DOB As Variant, EDC As Variant) As Single 'Returns the gestation in the form x.y where x is the number of completed weeks 'and y is the additional days, which ...
Started 3 weeks, 1 day ago (2009-11-30 18:46:00)
by JohnM
I want to create a function to return the gestational age of babies on their date of birth (DOB) with reference to the due date (the estimated date of confinement or EDC). The function I have at the moment is: Function Gest(DOB As Variant, EDC As Variant) As Single 'Returns the gestation in the form x.y where x is the...
Started 3 weeks, 1 day ago (2009-11-30 16:54:00)
by Brad Herder
Hi, SQL*Server 2005... We want to use a feature of a 3rd party package which lets you execute an sql select statement to retrieve info from our database. What we want to do is not only retrieve the info, but update the table it comes from to indicate the data has been extracted (so a subsequent call does not retrieve info that's already been extracted). I found you couldn't do updates in a ...
Started 3 weeks, 2 days ago (2009-11-30 09:31:00)
by Brad Herder
Hi, SQL*Server 2005... We want to use a feature of a 3rd party package which lets you execute an sql select statement to retrieve info from our database. What we want to do is not only retrieve the info, but update the table it comes from to indicate the data has been extracted (so a subsequent call does not retrieve info that's already been ...
Started 3 weeks, 6 days ago (2009-11-25 16:17:00)
by DogLover
I have a function that I created. When I test it in the Intermediate Window, ? Kountifs("Registered Nurse"), it returns a 12 which is correct. I want to be able to use this function a my datasheet. I have included basically the same function =Kountifs("Registered Nurse"). But, ont the datasheet I receive a #Value! rather than the 12. Does anyone have ideas why?
Started 1 week ago (2009-12-16 00:16:00)
by Henry Stockbridge
On Dec 15, 4:54 pm, Chip Pearson wrote: > Are you sure that the cell being changed is a parameter to the > function? For example, > > Function Times10(D As Double) As Double > Times10 = D*10 > End Function > > called in a formula as =Times10(A1) > > will calculate when A1 is changed. However, >...
Started 5 days, 4 hours ago (2009-12-18 05:45:00)
by dayneo
Like the others said, the SQL is incomplete. The unpeg is a function in a different schema and it is a user-defined function (not an oracle built-in). The "lag(counter1)over(order by counter2,counter3 asc,counter4 asc)" is an Oracle analytic function which allows for group aggregation and processing within a result set. See: ORACLE-BASE - LAG and LEAD Analytic Functions or the oracle ...
