Reminder in MS Excel 2003

Closed
nabarajs3
Posts
1
Registration date
Tuesday October 23, 2012
Status
Member
Last seen
October 23, 2012
- Oct 23, 2012 at 03:15 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Oct 23, 2012 at 09:57 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Oct 23, 2012 at 06:57 AM
search on the forum. If you even use your message title you would see some threads on the subject
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Oct 23, 2012 at 09:57 AM
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
0