Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells loosing there functions | Excel Worksheet Functions | |||
Remove Modules not working | Excel Programming | |||
Calling functions in different modules | Excel Programming | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
VBA & XL2K: Working with objects/class modules | Excel Programming |