DEAR ALL

I have declared in one sheet -varchk- variable as public and in the
sub procedure declared it as static -static varchk-. I am carrying the
results in a worksheet to another module thro this static variable
varchk. But the value of this varchk is not showing in the sub
procedure in the module. Pls adv.

Declare the variable one time only, in a standard module above any subs or
functions.
--
Gary''s Student
gsnu200703


"CAPTGNVR" wrote:

DEAR ALL

I have declared in one sheet -varchk- variable as public and in the
sub procedure declared it as static -static varchk-. I am carrying the
results in a worksheet to another module thro this static variable
varchk. But the value of this varchk is not showing in the sub
procedure in the module. Pls adv.

DEAR GARYS

Thnks yr response. yes that works. I am able to do the calculations
in modules and carry these variables to worksheet procedures.

What i need is asf:
In worksheet procedure using a command button click one result is
obtained say total cargo figures and say the variable name is -
cgofigs-. I want this variable -cgofigs- to be taken to standard
module to carryout other calculations using this variable -cgofigs-
result. pls advice.






On Feb 1, 9:38 pm, Gary''s Student
wrote:
Declare the variable one time only, in a standard module above any subs or
functions.
--
Gary''s Student
gsnu200703

"CAPTGNVR" wrote:
DEAR ALL

I have declared in one sheet -varchk- variable as public and in the
sub procedure declared it as static -static varchk-. I am carrying the
results in a worksheet to another module thro this static variable
varchk. But the value of this varchk is not showing in the sub
procedure in the module. Pls adv.