Advertisement
ba5tz

Ambil Ulang

Apr 6th, 2019
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.49 KB | None | 0 0
  1. Private Sub txtREALISASI_Exit(ByVal Cancel As MSForms.ReturnBoolean)
  2. 'Ambil ulang value nya
  3. With Sheet2.Range("A:A")
  4.     Set c = .Find(ComboBox1.Value, lookin:=xlValues)
  5.     If Not c Is Nothing Then
  6.         AnggaranAwal = c.Offset(0, 3).Value
  7.     End If
  8. End With
  9. if txtREALISASI.value > AnggaranAwal then
  10.     'kalau masih error coba conver ke long jadi
  11.     'if Clng(txtINPUT.value) > AnggaranAwal then
  12.     msgbox "MOHON DIPERIKSA KEMBALI HASIL INPUTAN MELEBIHI ANGGARAN"
  13. end if
  14. end Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement