Dear Bahtiyar saya juga baru belajar VBA, muridnya Mas Kid di kopdar#2. mencoba untuk mengoprek macronya almarhum mbah SitiVi
untuk pemicu yang kemarin menggunakan 2cell N7 dan M7, diganti menjadi satu cell saja pada H7: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$H$7" Then 'jika cell H7 diubah If Time < 9 / 24 Then 'jika sebelum pukul 9 HadirButton_Click 'dipilih absent masuk Else 'jika sesudah pukul 9 PulangButton_Click 'dipilih absent pulang End If End If End Sub semoga tidak ada yang keliru, jika masih ada yang keliri dapat ditanyakan kembali di milis. Salam 2015-02-12 19:49 GMT+07:00 'Mr. Kid' [email protected] [belajar-excel] < [email protected]>: > > > oh begitu kebijakannya... > > nah... sekarang sudah lebih jelas batasan dan alur prosesnya. > monggo para penggemar VBA dan yang sedang giat belajar VBA untuk mencoba > merumuskan bait-bait script-nya... > > ;) > > Wassalam, > Kid. > > > > by: "Mr. Kid" <[email protected]> > ------------------------------ > Reply via web post > <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/35476;_ylc=X3oDMTJyaHJuaGlkBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMzNTQ3NgRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0MjM3NDUzNzA-?act=reply&messageNum=35476> > • Reply to sender > <[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Tanya%20Presensi%20Siswa> > • Reply to group > <[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Tanya%20Presensi%20Siswa> > • Start a New Topic > <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJmMTQ0cnNqBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE0MjM3NDUzNzA-> > • Messages in this topic > <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/topics/35396;_ylc=X3oDMTM3cGhicHUxBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMzNTQ3NgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0MjM3NDUzNzAEdHBjSWQDMzUzOTY-> > (7) > ============================================================ > Pojok Lowongan Kerja yang disediakan milis : > > http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html > *** Posting lowongan kerja : ke link tersebut dan klik New Topic > ============================================================ > bergabung ke milis (subscribe), kirim mail kosong ke: > [email protected] > > posting ke milis, kirimkan ke: [email protected] > > berkunjung ke web milis : > http://tech.groups.yahoo.com/group/belajar-excel/messages > > melihat file archive / mendownload lampiran : > http://www.mail-archive.com/[email protected]/ > atau (sejak 25-Apr-2011) bisa juga di : > http://milis-belajar-excel.1048464.n5.nabble.com/ > > menghubungi moderators & owners: [email protected] > > keluar dari membership milis (UnSubscribe), kirim mail kosong ke : > [email protected] > --------------------------------------------------------------------- > Visit Your Group > <https://groups.yahoo.com/neo/groups/belajar-excel/info;_ylc=X3oDMTJmcmNkYjk5BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0MjM3NDUzNzA-> > > - New Members > > <https://groups.yahoo.com/neo/groups/belajar-excel/members/all;_ylc=X3oDMTJna29hNnVtBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxNDIzNzQ1Mzcw> > 12 > > [image: Yahoo! Groups] > <https://groups.yahoo.com/neo;_ylc=X3oDMTJldHRoMDNyBF9TAzk3NDc2NTkwBGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTQyMzc0NTM3MA--> > • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> • > Unsubscribe > <[email protected]?subject=Unsubscribe> • Terms > of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/> > > . > > >
PRESENSI.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
