السلام عليكم
الكود الاخير بعد التجربه يسبب ثقل على الملف
استخدم هذا التعديل
الكود التالي في مودويل
Const KL_NAMELENGTH = 9
Const KT_TYPE = 0
Const KT_SUBTYPE = 1
Const KT_FUNCTIONKEYS = 2
Public Declare Function GetKeyboardLayoutName Lib "user32" Alias "GetKeyboardLayoutNameA" (ByVal pwszKLID As String) As Long
Public Declare Function GetKeyboardType Lib "user32" (ByVal nTypeFlag As Long) As Long
Public Bn As Boolean
Public Function Ch_Bn() As String
Dim S_nm As String
S_nm = String(KL_NAMELENGTH, 0)
GetKeyboardLayoutName S_nm
Ern = IIf(Right(S_nm, 2) = 1, "Ar", "En")
Ch_Bn = Ern
End Function
Sub Dir_B()
Ch_Bn
Select Case Ch_Bn
Case Is = "Ar"
Bn = True
Debug.Print Bn
Case Is = "En"
Bn = False
Debug.Print Bn
End Select
End Sub
وهذا الكود في حدث Thisworkbook
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Set Sh = ActiveSheet
If Not Intersect(Target, Sh.Range("B5:B32")) Is Nothing Then
Call Dir_B
If Bn = True Then SendKeys "%+"
Else
Call Dir_B
If Bn = False Then SendKeys "%+"
End If
End Sub
مانفست كلابشة_Ali.rar