Guest
25-09-12, 11:11 PM
هل توجد دالة فى لغة الvb لاختصار الكسر الاعتيادى
مثلآ أكتب لها 12/30 فتعطينى الناتج 2/5
أم لابد من عمل كود لهذا الغرض؟
ولكم ألف شكر
مثلآ أكتب لها 12/30 فتعطينى الناتج 2/5
أم لابد من عمل كود لهذا الغرض؟
ولكم ألف شكر
Public Sub ReduceFraction(ByVal Number1 As Long, ByVal Number2 As Long, ByRef Result1 As Variant, ByRef Result2 As Variant)
Dim MaxDivider As Long
Dim ADivider As Long
Dim SmallerNumber As Long
Result1 = Null
Result2 = Null
If Number1 = 0 Then
Result1 = 0
'Result2 = 0
ElseIf Number2 = 0 Then
Err.Raise vbObjectError + 1001, App.EXEName, "القسمة على صفر"
ElseIf Number2 = Number1 Then
Result1 = 1
Result2 = 1
ElseIf Number2 < Number1 Then
If (Number1 Mod Number2) = 0 Then
Result1 = Number1 \ Number2
Result2 = 1
Else
SmallerNumber = Number2
End If
Else
If (Number2 Mod Number1) = 0 Then
Result1 = 1
Result2 = Number2 \ Number1
Else
SmallerNumber = Number1
End If
End If
If IsNull(Result1) Then
If (SmallerNumber Mod 2) = 0 Then
MaxDivider = SmallerNumber \ 2
Else
MaxDivider = (SmallerNumber - 1) \ 2
End If
Result1 = Number1
Result2 = Number2
For ADivider = MaxDivider To 2 Step -1
If ((Number1 Mod ADivider) = 0) And ((Number2 Mod ADivider) = 0) Then
Result1 = Number1 \ ADivider
Result2 = Number2 \ ADivider
Exit For
End If
Next ADivider
End If
End SubPrivate Sub Command1_Click()
Dim Number1 As Long
Dim Number2 As Long
Dim Number3 As Variant
Dim Number4 As Variant
Number1 = CLng(Text1.Text)
Number2 = CLng(Text2.Text)
ReduceFraction Number1, Number2, Number3, Number4
If IsNull(Number3) Then
Text3.Text = ""
Else
Text3.Text = CStr(Number3)
End If
If IsNull(Number4) Then
Text4.Text = ""
Else
Text4.Text = CStr(Number4)
End If
End Sub