User Defined Function
Try adding a catch-all "Case Else" to your Select to see if your other
cases aren't being triggered
Tim
On Jan 23, 9:33*am, Yugi Gokavarapu <yugandhar.gokavarapu-
wrote:
Hello There,
When I *write User Defined Function as below and use it, it returns
the output in the function argument dialogue box, but the out put is
not shown in the cell I wanted, instead I still see FALSE. *The cell
type I use is "General".
Function test(num)
* * Select Case num
* * * * *Case Is 0
* * * * * * * *test = "Positive"
* * * * Case Is = 0
* * * * * * * *test = "Zero"
* * * * Case Is < 0
* * * * * * * *test = "Negative"
* * End Select
End Function
Your help is appreciated!!
|