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:

Global iTable As Integer

2. One of my subs that change its value:

Private Sub txtProduct1_Enter()
    iTable = 3
End Sub

3. Sub where I call it with a Select Case

Private Sub populateTxtOnEnter(ByVal copy As String, ByVal iTable As Integer)
    Select Case iTable
    Case 1
        MsgBox "ERROR"
        txtClient.Value = copy
        textTicket.SetFocus
    Case 2
        textTicket.Value = copy
        txtProduct1.SetFocus
    Case 3
        txtProduct1.Value = copy
        'txtSize1.SetFocus
    Case 4
        txtSize1.Value = copy
        txtQuantity1.SetFocus
    'Case 5
    'Case 6
    'Case 7
    Case 8
        txtProduct2.Value = copy
        txtSize2.SetFocus
    Case 9
        txtSize2.Value = copy
        txtQuantity2.SetFocus
    'Case 10

    End Select
    
End Sub

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?