Selasa, 12 Desember 2017

TUGAS 3.7


Private Sub BATAL_Click()
TXTNK = ""
TXTNIK = ""
TXTGOL = ""
TXTKS = ""
TXTSTS = ""
TXTTH = ""
TXTJBT = ""
TXTBG = ""
TXTGP = ""
TXTTJ = ""
TXTTG = ""
TXTNK.SetFocus
End Sub

Private Sub KELUAR_Click()
Unload Me
End Sub

Private Sub LAGI_Click()
TXTNK = ""
TXTNIK = ""
TXTGOL = ""
TXTKS = ""
TXTSTS = ""
TXTTH = ""
TXTJBT = ""
TXTBG = ""
TXTGP = ""
TXTTJ = ""
TXTTG = ""
TXTNK.SetFocus
End Sub

Private Sub PROSES_Click()
Dim S As String
TXTTH = Left(TXTNIK, 4)
S = Mid(TXTNIK, 5, 1)
If S = "A" Then
TXTGOL = "A"
TXTJBT = "Manajer"
TXTGP = "4000000"
TXTTJ = "1025000"
ElseIf S = "B" Then
TXTGOL = "B"
TXTJBT = "Ka. Seksi"
TXTGP = "3500000"
TXTTJ = "975000"
ElseIf S = "C" Then
TXTGOL = "C"
TXTJBT = "Staff"
TXTGP = "3000000"
TXTTJ = "925000"
End If
S = Mid(TXTNIK, 7, 1)
If S = "S" Then
TXTKS = "S"
TXTSTS = "Single"
ElseIf S = "M" Then
TXTKS = "M"
TXTSTS = "Menikah"
ElseIf S = "J" Then
TXTKS = "J"
TXTSTS = "Janda"
ElseIf S = "D" Then
TXTKS = "D"
TXTSTS = "Duda"
End If
S = Right(TXTNIK, 3)
If S = "KEU" Then
TXTBG = "Accounting"
ElseIf S = "ADM" Then
TXTBG = "Administrasi"
ElseIf S = "SDM" Then
TXTBG = "General Affair"
ElseIf S = "EDP" Then
TXTBG = "IT Unit"
ElseIf S = "SPM" Then
TXTBG = "Security"
End If
TXTTG = Val(TXTGP) + Val(TXTTJ)
End Sub

Tidak ada komentar:

Posting Komentar

TUGAS 3.7

Private Sub BATAL_Click() TXTNK = "" TXTNIK = "" TXTGOL = "" TXTKS = "" TXTSTS = "" TXTTH...