User Defined Function
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!! |
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!! |
User Defined Function
Yugi Gokavarapu has brought this to us :
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!! It works fine for me 'as is'! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
User Defined Function
On Jan 23, 3:04*pm, GS wrote:
Yugi Gokavarapu has brought this to us : 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!! It works fine for me 'as is'! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc I wonder why it is not working, any settings need to be modified? |
User Defined Function
It could be that a function by default returns a boolean value (True/
False). Try changing it to return a text value: Function Test(num) as String -pb |
User Defined Function
Yugi Gokavarapu explained on 1/24/2012 :
On Jan 23, 3:04*pm, GS wrote: Yugi Gokavarapu has brought this to us : 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!! It works fine for me 'as is'! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc I wonder why it is not working, any settings need to be modified? WHERE is the function located? It should in a standard module! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com