How to use global variables in VBA?

Hello, trying to implement a global variable iTable that I can increment/decrement and use its value anytime needed.

1. globalvariables module:

Please Login or Register  to view this content.

2. One of my subs that change its value:

Please Login or Register  to view this content.

3. Sub where I call it with a Select Case

Please Login or Register  to view this content.

Now, altough I enter txtProduct1 TextBox, and my iTable is changed to 3, when the code reachs the Select Case, it always goes Case 1 and displays "ERROR" MsgBox that I created. I ask you why?

I tried a MsgBox on txtProduct1_Enter and it give me iTable = 3.

Private Sub populateTxtOnEnter(ByVal copy As String, ByVal id As Integer)
Select Case id
...

Made this change and it still always goes back to 1. I remember that in java the arguments were local, meaning that they could have any name you want, it wouldnt override. In VBA all variables/arguments variables must be unique?

You are absolutely right. Im beginning to figure out my problem. Its all fine on the global variable. Its actually my 1109 lines code thats getting complex. Summarizing it, I did a bunch of MsgBox on my subroutines to track down iTable value.

It appears to me that theres other sub calling txtClient_Enter that has iTable = 1 inside... I must now wonder what subs are related, wich ones call wich ones, etc. Any suggestion or approach for this?