I am having trouble with keeping Public variables within scope. The variables are declared as arguments into a function. Within that function, there is a call to another Subroutine. When the code progress into the Subroutine, the values of the variables are lost/reset rather than retained at their originally defined values.
Can anyone tell me a way around this? besides combining all the code explicitly within the function
Please Login or Register to view this content.
First, public variables are declared outside the scope of any procedure.
Second, your static function doesn't show any declared variables.
So ... I don't understand your question.
Entia non sunt multiplicanda sine necessitate
well, I thought the call to the function WAS the variable declaration
I can't define them inside the function since it would be a duplicate declaration
I have also tried declaring them public outside (above) the beginning of the function, but the same problem occurs (values are lost)
I am hampered by not having a clue what you're trying to do.
Can you explain?
my objectives are two-fold:
1. define SINDAmodel as a Function, such that is can be used as a Worksheet function
2. declare the input arguments to SINDAmodel as Public variables, such that they can be passed among other procedures while retaining their values
First, only Functions (not Subs) can be invoked from the worksheet, and in that context, such functions are called UDFs (User-Defined ~).
Second, no UDF can do anything (with some arcane exceptions) other than return a value to the cell in which it's entered. That restriction continues to any sub called by a UDF.
You can have a UDF that returns values to the worksheet that were calculated by a Sub:
Please Login or Register to view this content.
I should add that if the variables don't need to be seen outside the module in which they are declared, replace Public with Dim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks