Use the same Variable in the module

[Romulo Avila]

Good afternoon,


I am in need of help, I have an event "BeforeDoubleClick" as below

Option Explicit
Public Line As Integer


Private Sub Worksheet_BeforeDoubleClick (ByVal Target As Range, Cancel As Boolean)


If Not Intersect ([B2: B10], Target) Is Nothing Then Target.Value = IIf (Target.Value = "", "ok", "")
Line = Target.Row
Call call
Cancel = True
End Sub

Where do I need to use the value of the variable within a module (I did this example)

Sub test ()
    MsgBox Line
End Sub

Only when it goes to the Module the variable is empty, how can I solve it.


Thank you

RomuloRDM

[Paul_Hossler]

In the WS module

Option Explicit


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect([B2: B10], Target) Is Nothing Then Target.Value = IIf(Target.Value = "", "ok", "")

    Line = Target.Row
    test
    Cancel = True
End Sub

In a standard module

Option Explicit


Public Line As Integer


Sub test()
    MsgBox Line
End Sub

[Romulo Avila]

Paul,
Good afternoon,


Thank you very much, it worked.