What is the function of a Function?
Posted: Mon Feb 29, 2016 7:00 pm
Product, version and build: PS 2015
32 or 64 bit version of product: 64
Operating system: W7
32 or 64 bit OS: 64
I am trying to figure out whether or not a Function returns the value it generates by its own name. I have this code:
Function readInput(CellIndex)
' debug
WScript.Echo "In readInput"
readInput = InputBox("Enter Coefficient " & CellIndex, vbOKOnly+vbQuestion, "Coefficient Entry")
' debug
WScript.Echo "Entered datum was " & readInput <------ This code works fine <------
End Function ' readInput
' ----------------------------------------------------------------------------
Sub validateTheDatum(DataArray, RunTheProgram, CellIndex, ValidSignal)
' Selection Sub to ensure only numeric data is returned
' debug
WScript.Echo "In validateTheDatum"
Dim val
val = readInput CellIndex <------ Debug expects 'End of Statement' here <------
wscript.Echo val
' After debugging, working code will go here
' debug
ValidSignal = False
WScript.Echo "validateTheDatum just changed ValidSignal to" & ValidSignal
End Sub ' validateTheDatum
I am expecting the variable 'val' to get take the value the User enters in the InputBox. Debug says there is something wrong with the statement.
What have I misinterpreted?
32 or 64 bit version of product: 64
Operating system: W7
32 or 64 bit OS: 64
I am trying to figure out whether or not a Function returns the value it generates by its own name. I have this code:
Function readInput(CellIndex)
' debug
WScript.Echo "In readInput"
readInput = InputBox("Enter Coefficient " & CellIndex, vbOKOnly+vbQuestion, "Coefficient Entry")
' debug
WScript.Echo "Entered datum was " & readInput <------ This code works fine <------
End Function ' readInput
' ----------------------------------------------------------------------------
Sub validateTheDatum(DataArray, RunTheProgram, CellIndex, ValidSignal)
' Selection Sub to ensure only numeric data is returned
' debug
WScript.Echo "In validateTheDatum"
Dim val
val = readInput CellIndex <------ Debug expects 'End of Statement' here <------
wscript.Echo val
' After debugging, working code will go here
' debug
ValidSignal = False
WScript.Echo "validateTheDatum just changed ValidSignal to" & ValidSignal
End Sub ' validateTheDatum
I am expecting the variable 'val' to get take the value the User enters in the InputBox. Debug says there is something wrong with the statement.
What have I misinterpreted?