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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 23, 2012 at 09:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 23, 2012 at 09:57 AM
Related:
- Reminder in MS Excel 2003
- Ms excel free download - Download - Spreadsheets
- Ms excel marksheet - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- How to take screenshot in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 23, 2012 at 06:57 AM
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 23, 2012 at 09:57 AM
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:
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:
Best regards,
Trowa
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
