Sometime when we work we forget about our appointment/promise with our friend, but don’t worry we can make a remainder with VBA. . 1. Open Your WorkBook 2. Click Visual Basic Editor / ALT + F11. 3. Click Insert | Module
4. Type the this code - For the message Sub Pesan() MsgBox “Sudah Jam 10.30 Sholat Duha Dulu” End Sub - For the Alarm Time. Sub PanggilPesan() Application.OnTime TimeValue(“10:30:00”), “Pesan” End Sub You can arrange with another format time, such 10:30:00 am, Remember to delete the code before you close your workbook. But if you want arrange with specific time you can type the code : Application.OnTime DateValue(“mounth/day/years Time”), “Pesan” If you use this arrange you must save your workbook as Excel Macro-Enabled Workbook (xlsm). And if you macro open with save you maust save on Trusted Location, and too make Truste Locations : 1. Click Macro Security on Tab Developer 2. Click Trusted Location 3. Click Add New Location and choose Folder you want.. Download Tutorial -- Posting oleh mister.ahmad ke Tips and Trick pada 12/23/2009 02:07:00 AM -- You received this message because you are subscribed to the Google Groups "Gugukluhayat" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/gugukluhayat?hl=en.
