Reminder in MS Excel 2003

[Closed]
Report
Posts
1
Registration date
Tuesday October 23, 2012
Status
Member
Last seen
October 23, 2012
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hello,

I would like to add reminder which displays reminder message once it opens. Onething I dont know the VB or something extra programming software.


Regards,
nabarajs3

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
search on the forum. If you even use your message title you would see some threads on the subject
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Nabarajs3,

Without experience in VB, things could get confusing.

This is a simple code which runs when the workbook is opened:
Private Sub Workbook_Open()
MsgBox "You just got reminded"
End Sub

How to implement:
When running Excel hit Alt+F11 to open VB. Look on the left side of the window that just opened. Here you will find your sheets as well as ThisWorkbook. Double click ThisWorkbook and paste the code in the big white field.

Now save and close Excel. Open your file again and a message box will appear.

To change you reminder message you can go to VB again or you can put your message in a cell and use the following code:
Private Sub Workbook_Open()
MsgBox Sheets("Sheet1").Range("A1").Value
End Sub

Best regards,
Trowa