Sub test() Dim hari As Byte hari = Weekday(VBA.Date) If hari = 1 Then MsgBox "Ahad" ElseIf haari = 2 Then MsgBox "Senin" ElseIf hari = 3 Then MsgBox "Selasa" Else MsgBox "rabu" End If End Sub
Langganan:
Posting Komentar (Atom)
Menghitung USIA Excel
=BYROW(D2:D100; LAMBDA(tanggal_lahir; IF(tanggal_lahir=""; ""; DATEDIF(tanggal_lahir; TODAY(); "y"...
-
klik di sni
-
Option Explicit Sub cetaktabungansetoran() Dim rujukan As Range Dim b As Long Set rujukan = Sheets("CETAKTABUNGAN").Range(...
-
Option Explicit Private Sub CDMDDELETE_Click() Application.ScreenUpdating = False Me.TABELDATA.value = "" If Me.TXTNISN.valu...
Tidak ada komentar:
Posting Komentar