DefSng A-Z

Dim a(7), b(7) As String, c(7), d(7) As String, e(7), f(7), g(7), h(7), k(7), af(7), bf(7), cf(7), aft(7), bft(7), cft(7), tmp As Variant, ct, a1(7), b1(7) As String, c1(7), z As String

----------------------------------------------------------------

Private Sub Command1_Click()

    ct = ct + 1

    a(ct) = Text1.Text

    b(ct) = Text2.Text

    c(ct) = Text3.Text

    a1(ct) = Text1.Text

    b1(ct) = Text2.Text

    c1(ct) = Text3.Text

    Text1.Text = ""

    Text2.Text = ""

    Text3.Text = ""

    Text1.SetFocus

End Sub

----------------------------------------------------------------

Private Sub Command2_Click()

    For i = i To ct - 1

        For j = i + 1 To ct

            If b(i) > b(j) Then

                tmp = a(i): a(i) = a(j): a(j) = tmp

                tmp = b(i): b(i) = b(j): b(j) = tmp

                tmp = c(i): c(i) = c(j): c(j) = tmp

            End If

        Next j

    Next i

    For i = i To ct

        Select Case a(i)

            Case "501": z = "A"

            Case "502": z = "C"

            Case "503": z = "A"

            Case "504": z = "B"

            Case "505": z = "B"

            Case "506": z = "B"

            Case "507": z = "C"

            Case "508": z = "A"

            Case "509": z = "C"

            Case "510": z = "A"

        End Select

        e(i) = c(i)

        Select Case UCase(b(i))

            Case "PA": d(i) = "모니터": x = 99: y = 8000

            Case "PB": d(i) = "키보드": x = 35: y = 7000

            Case "PC": d(i) = "마우스": x = 95: y = 6000

            Case "PD": d(i) = "CPU": x = 85: y = 14000

            Case "PE": d(i) = "스캐너": x = 28: y = 61000

            Case "PF": d(i) = "프린터": x = 16: y = 3000

            Case "PG": d(i) = "메모리": x = 150: y = 35000

            Case "PH": d(i) = "모뎀": x = 168: y = 16000

        End Select

        aft(i) = af(i) * y

        bft(i) = bf(i) * y

        cft(i) = cf(i) * y

        k(i) = Int((e(i) / x) * 100 + 0.5)

    Next i

    Form1.Hide

    Form2.Show

    Form2.Print "비번호 : 004666"

    Form2.Print ""

    Form2.Print "판매제품, 판매수량, A등급판매금액, B등급판매금액, C등급판매금액, 판매율"

    For i = 1 To ct

        Form2.Print d(i), e(i), aft(i), bft(i), cft(i), k(i)

    Next i

    Form2.Print ""

    Form2.Print "입력자료"

    For i = 1 To ct

        Form2.Print a1(i), b1(i), c1(i)

    Next i

End Sub