Make the target active and ready for entering data

[YasserKhalil]

Hello everyone
I have a code in worksheet selectionchange

Code: Select all

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.CountLarge > 1 Then Exit Sub
    If Target.Column > 5 And Target.Column <= 19 Then
        If Target.Value = "-" Then
        Target.Select
        Application.SendKeys "{F2}"
        LettersForm.Show 0
        
        
        End If
    End If
End Sub

I need to make the target cell to be ready for entering data directly even with the userform LettersForm is shown. I tried to make it modeless by adding and also tried Target.Select and even tried Application.SendKeys "{F2}" but nothing worked. I have to select the cell again manually.

[HansV]

I think that it's impossible to do what you want.

[YasserKhalil]

Thanks a lot my tutor.