Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |