View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SupperDuck SupperDuck is offline
external usenet poster
 
Posts: 44
Default Loosing values when working on different functions and modules..

Hello,

I have a userform, and buttons on it...

I have a module, called lnCalculate

And functions..

ln1Calculate
ln2Calculate
...


When i press first button it makes;

a = 6

total = a+b+c+d+e

and second;

b= 7

total=a+b+c+d+e

so in this second step, I want to get a value, 13

But.. I got 7. What i guess is, after finishing first function, all data is
cleared

a,b,c,d,e are identified as double in the forms module...

I do not want to loose the values for a, b, c, d, e.. I want them to save
their values even they are used in different functions or different modules.

I just want them to clear their values only when i want (e.g a=0, b=0.. )

So how must define them so they will not loose their values?

thanks in advance,