Sometime when we work we forget about our appointment, but don’t worry
we can make a remainder with VBA..1. Open your Word Doc

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 When:=“10:30:00”, Name:=“Pesan”
End Sub



You can arrange with another format time, such 10:30:00 am, Remember to
delete the code
before you close your WordDocument
But if you want arrange with specific time you can type the code :
Application.OnTime When:=”Mounth/Day/Years Jam”, Name:=”Pesan”
If you use this arrange you must save your Word Document as
Macro-Enabled Document(docm).
And if you macro open with save you must 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:25: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.


Cevap