View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default STATIC VARIABLE NOT AVAILABLE IN ANOTHER MODULE

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.