vba returning and using value from funciton code example
Example: vba function return
Function SumNumbers(pNum1 As Long, pNum2 As Long) As Long
SumNumbers = pNum1 + pNum2
End Function
Function SumNumbers(pNum1 As Long, pNum2 As Long) As Long
SumNumbers = pNum1 + pNum2
End Function