Vincent88
Active Member
- Joined
- Mar 5, 2021
- Messages
- 382
- Office Version
- 2019
- Platform
- Windows
- Mobile
I got error when I tried to create two selectionchange. How should I correct it ?
The code is
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("C1")) Is Nothing Then
Call Module4.Check
ElseIf Not Intersect(Target, Range("A2:A")) Is Nothing Then
Call Module15.ExtractNumbers2
Exit Sub
End If
End If
End Sub
The code is
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("C1")) Is Nothing Then
Call Module4.Check
ElseIf Not Intersect(Target, Range("A2:A")) Is Nothing Then
Call Module15.ExtractNumbers2
Exit Sub
End If
End If
End Sub