Romulo Avila
04-12-2020, 09:39 AM
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
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