جزاك الله خيرا أخى الحبيب وونفع الله بك
وارجو منك تعديل الكود بهذه الحروف من خلال هذا الكود
Public Function ReplaceString(In_Text As String) As String
Dim X As Long
Dim strChar As String
Dim strReturn As String
For X = 1 To Len(In_Text)
strChar = Mid(In_Text, X, 1)
Select Case strChar
Case "أ", "إ", "آ"
strChar = "ا"
Case "ه"
strChar = "ة"
Case "ؤ"
strChar = "و"
Case "ئ", "ي"
strChar = "ى"
'' تجاوز التشكيل عند البحث
Case "َ", "ِ"
strChar = ""
Case "~", "ً"
strChar = ""
Case "ٍ", "ْ"
strChar = ""
Case "ُ", "ٌ", "ّ"
strChar = ""
Case "ـ"
strChar = ""
End Select
strReturn = strReturn & strChar
Next
DoEvents
ReplaceString = strReturn
End Function