داله لتفقيط الارقام بجميع العملات

لا توجد دالة ولكن توجد دالة وجدتها فى احدى المواقع

ارجو ان تفيدك

Public Function monytext(ByVal X As Double)
Dim Ma As String
Dim Mi As String
Dim n As Long
Dim b As Double
Dim R As String
Ma = " دينار"
Mi = " درهم"
n = Int(X)
R = SHorof(n)
b = Val(Right$(Format(X, "000000000000.000"), 3))
Dim Result As String
If R <> "" And b > 0 Then Result = R & Ma & " و " & b & Mi
If R <> "" And b = 0 Then Result = R & Ma
If R = "" And b <> 0 Then Result = b & Mi
monytext = Result
End Function

Private Function SHorof(ByVal X As Long)
Dim C As String
Dim C1 As String
C = Format(X, "000000000000")
C1 = Val(Mid(C, 12, 1))
Dim Letter1 As String
Select Case C1
Case Is = 1: Letter1 = "واحد"
Case Is = 2: Letter1 = "اثنان"
Case Is = 3: Letter1 = "ثلاثة"
Case Is = 4: Letter1 = "اربعة"
Case Is = 5: Letter1 = "خمسة"
Case Is = 6: Letter1 = "ستة"
Case Is = 7: Letter1 = "سبعة"
Case Is = 8: Letter1 = "ثمانية"
Case Is = 9: Letter1 = "تسعة"
End Select

Dim C2 As Long
C2 = Val(Mid(C, 11, 1))
Dim Letter2 As String
Select Case C2
Case Is = 1: Letter2 = "عشر"
Case Is = 2: Letter2 = "عشرون"
Case Is = 3: Letter2 = "ثلاثون"
Case Is = 4: Letter2 = "اربعون"
Case Is = 5: Letter2 = "خمسون"
Case Is = 6: Letter2 = "ستون"
Case Is = 7: Letter2 = "سبعون"
Case Is = 8: Letter2 = "ثمانون"
Case Is = 9: Letter2 = "تسعون"
End Select

If Letter1 <> "" And C2 > 1 Then Letter2 = Letter1 + " و" + Letter2
If Letter2 = "" Then Letter2 = Letter1
If C1 = 0 And C2 = 1 Then Letter2 = Letter2 + "ة"
If C1 = 1 And C2 = 1 Then Letter2 = "احدى عشر"
If C1 = 2 And C2 = 1 Then Letter2 = "اثنى عشر"
If C1 > 2 And C2 = 1 Then Letter2 = Letter1 + " " + Letter2

Dim C3 As Long

C3 = Val(Mid(C, 10, 1))
Dim Letter3 As String
Select Case C3
Case Is = 1: Letter3 = "مائة"
Case Is = 2: Letter3 = "مئتان"
Case Is > 2: Letter3 = Left(SHorof(C3), Len(SHorof(C3)) - 1) + "مائة"
End Select
If Letter3 <> "" And Letter2 <> "" Then Letter3 = Letter3 + " و" + Letter2
If Letter3 = "" Then Letter3 = Letter2

Dim C4 As Long
C4 = Val(Mid(C, 7, 3))
Dim Letter4 As String
Select Case CLng(C4)
Case Is = 1: Letter4 = "الف"
Case Is = 2: Letter4 = "الفان"
Case 3 To 10: Letter4 = SHorof(C4) + " آلاف"
Case Is > 10: Letter4 = SHorof(C4) + " الف"
End Select
If Letter4 <> "" And Letter3 <> "" Then Letter4 = Letter4 + " و" + Letter3
If Letter4 = "" Then Letter4 = Letter3

Dim C5 As Long
C5 = Val(Mid(C, 4, 3))
Dim Letter5 As String



Select Case C5
Case Is = 1: Letter5 = "مليون"
Case Is = 2: Letter5 = "مليونان"
Case 3 To 10: Letter5 = SHorof(C5) + " ملايين"
Case Is > 10: Letter5 = SHorof(C5) + " مليون"
End Select
If Letter5 <> "" And Letter4 <> "" Then Letter5 = Letter5 + " و" + Letter4
If Letter5 = "" Then Letter5 = Letter4

Dim C6 As Long
C6 = Val(Mid(C, 1, 3))
Dim Letter6 As String
Select Case C6
Case Is = 1: Letter6 = "مليار"
Case Is = 2: Letter6 = "ملياران"
Case Is > 2: Letter6 = SHorof(C6) + " مليار"
End Select
If Letter6 <> "" And Letter5 <> "" Then Letter6 = Letter6 + " و" + Letter5
If Letter6 = "" Then Letter6 = Letter5
SHorof = Letter6



End Function