Excel set time Reminders cleverly

Xiao Yu in the trading center, often to call the corresponding judges to participate in the project evaluation work, sometimes work a busy, forget the notice and affect the normal bid opening.

Because he used Excel every day to register the corresponding data, so I used Excel to set up a timer for him to remind the function. The end of the article provides the original document for everyone to download reference.

1, start Excel, create a new document, named Save (such as "Reminder. xls").

2, press "ALT+F11" key combination into the VBA edit state (Figure 1).

(larger picture, please pull the scroll bar to watch)

3. In the Project Explorer window on the left, select the VBAProject (Alert. xls) option, execute the Insert Module command, and insert a new module (module 1, see Figure 1).

4. Enter the following code into the editing area on the right:

Sub Auto_Open () to set up an Autorun macro--auto_open

Application.ontime timevalue ("08:30:00"), "TX" Set Reminder time--08:30:00 (can be modified as needed), set call Reminder macro--tx.

Application.ontime timevalue ("09:30:00"), "TX" To set a reminder again.

End Sub

Sub TX () Sets a macro that displays a reminder message (the name is consistent with the name called in the Autorun macro above).

msg = MsgBox ("Notify John, Dick, Harry judges to participate in the afternoon evaluation!", vbinformation, "Make a phone call") ' Set the message and caption in the Reminder dialog box (preceded by the message content, followed by the dialog box title, please enter as needed).

End Sub

Note: ① The above code, the English single quotes and the characters that follow them are an explanation of the code, which is not required when you actually enter it (see Figure 1). ② If you set multiple reminder macros (TX1, tx2 ...), and set the call time separately in the Autorun macro, you can implement a timed reminder of multiple messages.

5, after the input completes, exits the VBA edits the state, saves the workbook document.

6, later, one to go to work, start Excel, open the above workbook document. When you set the time, the system immediately pops up as shown in Figure 2, which is not forgotten. Original File Download

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join