Calling a function

[grkchakri]

Hi All

I am trying to write a function at module level. and a macro at sheet level. Basically the operator inputs a value through a input box, It should check in the function and retrieve the value. But it is just diplaying the value that i have input in the inputbox. I am quite naive in writing a function. I am

Please let me know whats wrong with the below code:

'At Module Level'

Please Login or Register  to view this content.

At the Sheet Level

Please Login or Register  to view this content.

[MrShorty]

But it is just diplaying the value that i have input in the inputbox.

Which is exactly what you have told it to do

Please Login or Register  to view this content.

It is not clear to me which of the two values x=200 or y=300 you want returned, but you will a statement assigning x or y to chkfees

[grkchakri]

Basically at a sheet level when the operator input a value it has to check in the case statment that we have written in the function.

*For example if a operator inputs a 110000 in the input box (which is there on the sheet level). The fees will be 200
*For example if a operator inputs a 150000 in the input box (which is there on the sheet level). The fees will be 300

So the input value should be checked in the case stattment and give the necesscary result.
Apologies if i was not clear in my first post

Many Thanx

[MrShorty]

Correct, and I assume the 200 and 300 represent the fees for the two cases. So, you need to assign one of those values (not the original s1_fee that was passed to the function) to the function name. Is there something wrong with the way I assigned x or y to chkfees in the modified code (other than I neglected to comment out the chkfees=s1_fee statement after the select case)?

[grkchakri]

Do we have to make any changes at sheet level as well. Cos it doesnt return any value. if i am using

Range("A1").Value = ChkFees(s1_fee)

However the function just work fine directly in the sheet where i give a value in a cell and use the function in other cell.

Also just wanted to check my understanding of function little more clearly

*When we create function it has to return some value , Like ChkFees in my example
* and the variables declared with in the (...) are the arugments passed to make the function work/create am right ?

[MrShorty]

I would say those are both essentially correct statements about functions.

As debugging as an important skill, and this one should not be overly difficult to debug, here's a hint/question that I believe will help you see where the problem is: What value are you passing to the function? Or, put another way, what value is in s1_fee when chkfees is called (use the locals window to check variable values while stepping through code http://www.bettersolutions.com/vba/V...D210310551.htm)? Hint: the answer to this question is not related to what you enter in the input box.