Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
Hi everybody,
I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
No idea?
"Martin J." wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
I'd guess that there was something wrong in the code you didn't share.
Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
Thanks for the advice.
This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
Do you have any unhandled errors in any other UDF?
Martin J. wrote: Thanks for the advice. This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
I don't have any other UDF atm.
"Dave Peterson" wrote: Do you have any unhandled errors in any other UDF? Martin J. wrote: Thanks for the advice. This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
You abbreviated code worked fine in my tests.
I don't have another guess. Martin J. wrote: I don't have any other UDF atm. "Dave Peterson" wrote: Do you have any unhandled errors in any other UDF? Martin J. wrote: Thanks for the advice. This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
I finally found my error, a bit silly.
I wrote a ',' instead of a ';' between the two arguments in the call of the function. Being used to other programming languages as java or c/c++, I obviously did not notice that difference. Btw, thanks a lot for trying helping me, Have a nice day, Martin "Dave Peterson" wrote: You abbreviated code worked fine in my tests. I don't have another guess. Martin J. wrote: I don't have any other UDF atm. "Dave Peterson" wrote: Do you have any unhandled errors in any other UDF? Martin J. wrote: Thanks for the advice. This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! error with custom excel vba function
That separator string is a windows setting.
For me (and my USA settings), the separator is a comma. Not for you! Glad you found it and thanks for posting back. Martin J. wrote: I finally found my error, a bit silly. I wrote a ',' instead of a ';' between the two arguments in the call of the function. Being used to other programming languages as java or c/c++, I obviously did not notice that difference. Btw, thanks a lot for trying helping me, Have a nice day, Martin "Dave Peterson" wrote: You abbreviated code worked fine in my tests. I don't have another guess. Martin J. wrote: I don't have any other UDF atm. "Dave Peterson" wrote: Do you have any unhandled errors in any other UDF? Martin J. wrote: Thanks for the advice. This is what I thought as well, but even if I set the inside of the function to this only line: GetSmokePower = 3 I get the same error... Any idea? Thanks by advance, Martin "Dave Peterson" wrote: I'd guess that there was something wrong in the code you didn't share. Martin J. wrote: Hi everybody, I get a #VALUE! error when using a custom function. Here is the code of the function (in a VBA module): Function GetSmokePower(PlantType As Integer, FuelType As Integer) ... ... GetSmokePower = Vswe End Function I just call this function that way in excel: =GetSmokePower(3,1) Did I do something wrong? Do I have to set some options on or off? Thanks a lot for helping me, Regards, Martin J. -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Custom error bars ?? | Charts and Charting in Excel | |||
Excel Custom Sort Error | Excel Discussion (Misc queries) | |||
cUSTOM error Bars in Excel 2007 | Excel Discussion (Misc queries) | |||
Custom Error Bar for Excel 2007 | Excel Discussion (Misc queries) | |||
Custom function returning VALUE error | Excel Discussion (Misc queries) |