Page 1 of 1

What is the function of a Function?

Posted: Mon Feb 29, 2016 8:00 pm
by vagulus
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?

Re: What is the function of a Function?

Posted: Tue Mar 01, 2016 12:44 am
by Alexander Riedel
Topic moved to correct forum by moderator

Re: What is the function of a Function?

Posted: Wed Mar 02, 2016 11:47 am
by jvierra
None of your functions return a value. They all return Null.