How does your macro know the value of RecentEvaluation?
--
Gary's Student
"Sherry" wrote:
Hello JulieD
I am sorry but I do not understand what you mean by passing in the parameter!!
I did however pick up on typo of OverallEval that should have been
OverallEvaluation
Any further elaboration would be helpful
Thank You Cheers Sherry
"JulieD" wrote:
Hi Sherry
two problems as i see it
one - you're only passing in the OverallEval parameter not the
RecentEvaluation parameter
two - you're passing in a parameter called "OverallEval" but calling it
"OveralLEvaluation" in the function itself
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Sherry" wrote in message
...
Please help.
I have created a Function (see below) but regardles of the numbers I
enter,
I can only get one result to display. That result is Poor-Improving
Grrrr! What am I missing here? can anyone help-Please!!!
Function EvalAll(OverallEval As Double)
If RecentEvaluation = OverallEvaluation And OverallEvaluation 4 Then
EvalAll = "Good-Improving"
ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation < 4
Then
EvalAll = "Poor-Improving"
ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation 4
Then
EvalAll = "Good-Improving"
ElseIf RecentEvaluation = OverallEvaluation And OverallEvaluation 4
Then
EvalAll = "Poor-Interview"
End If
End Function
I have looked at this for so long without success and now I am not sure
what
I am doing anymore!!!
Cheers Sherry