global variable and future sub

[lezawang]

Hi
I want to define a variable as a global so I can use it on all other sub()s in the module. It is working fine but I noticed one thing. If I created a new sub, lets say sub4(), then this sub4() will not be able to get the value of x unless I go to sub1() and run it again. Why is that? I thought once I run sub1() for the first time then X will be fixed (whatever user going to enter) for all current and future subs

dim x as integer

sub sub1()
   x=inputbox("input number")
end sub

sub sub2()
  msgbox x
end sub

sub sub3()
  msgbox x
end sub

 

[Jaafar Tribak]

Adding a new sub in the same module will reset the vbaproject and release all the variables within it.

How are you adding the new (future) sub(s) ? Is that manually or via code ?

And why are you adding the subs like that ? It sounds like a bad code design.