Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That was the problem, now it works.
Thanks, Stefi Snake Plissken ezt *rta: I suggest to declare variables before subs as follows option explicit dim var1, var2 as string dim var3, var5 as integer dim var4 as long etc. sub name_of_sub_1 () var1= "anystring" ....... end sub sub name_of_sub_2() var3= 5 var5= 6 ...... end sub Function name_of_f(...) 'here u can "read" value of variables from subs and perform a function end function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub - Only Accessible from same Module? | Excel Discussion (Misc queries) | |||
STATIC VARIABLE NOT AVAILABLE IN ANOTHER MODULE | Excel Discussion (Misc queries) | |||
Initialize a Private variable | Excel Programming | |||
Call Private Function from ThisWorkbook module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |