Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using subfunction in a function
Is it possible to refer to a subprocedure in a function?
I am trying to use a variable that is referred to in a function but is defined in a subfunction. I want the variable to retain a value with the end of the function. This is what I am trying to do: Sub CalculateTotal() total = timelapse + total End Sub Function Downtime(CurrentLoadSig, PrevLoadingSig, PastTime, PresentTime) 'Calculates the amount of time lapsed for downtime If CurrentLoadingSig = 0 Then Select Case PrevLoadSig Case Is = 0 timelapse = PrevTime - CurrentTime Downtime = total Case Is = 1 timelapse = PrevTime - CurrentTime Downtime = total Else total = total * 0 End Function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using subfunction in a function
I'm not clear exactly what you want your program to do, but my rewrite of
your program (below) should clarify some of your questions about how to use functions. HTH, Shockley Sub tester() cls = 0 pls = 1 preT = 30 CurT = 60 DTime = Downtime(cls, pls, preT, CurT) End Sub Function Total(timelapse) Total = timelapse + Total End Function Function Downtime(CurrentLoadSig, PrevLoadSig, _ PrevTime, CurrentTime) If CurrentLoadSig = 0 Then Select Case PrevLoadSig Case Is = 0 timelapse = CurrentTime - PrevTime Downtime = Total(timelapse) Case Is = 1 timelapse = CurrentTime - PrevTime Downtime = Total(timelapse) End Select Else Downtime = 0 End If End Function "Elizabeth" wrote in message ... Is it possible to refer to a subprocedure in a function? I am trying to use a variable that is referred to in a function but is defined in a subfunction. I want the variable to retain a value with the end of the function. This is what I am trying to do: Sub CalculateTotal() total = timelapse + total End Sub Function Downtime(CurrentLoadSig, PrevLoadingSig, PastTime, PresentTime) 'Calculates the amount of time lapsed for downtime If CurrentLoadingSig = 0 Then Select Case PrevLoadSig Case Is = 0 timelapse = PrevTime - CurrentTime Downtime = total Case Is = 1 timelapse = PrevTime - CurrentTime Downtime = total Else total = total * 0 End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
to call subfunction from a function | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |