Hi, please i need information on how to create a Date reminder that popup in Microsoft Excel e.g. my son's birthday. Thank you.
Hi, please i need information on how to create a Date reminder that popup in Microsoft Excel e.g. my son's birthday. Thank you.
@Ibk -
Not sure where/how you're trying to implement this code, but here is what I came up with for you:
It'd probably be best to have this routine in the Workbook_Open event, so that you don't have to press a button anywhere. This way it'll fire automatically when you open the workbook (assuming you have your Trust Center settings enabling macros automatically).
Please Login or Register to view this content.
Last edited by ww1711; 01-25-2012 at 02:00 PM. Reason: Placed Exit Sub in wrong If statement
I wouldn't automatically have macros enabled!!!!
You could list specific dates like birthdays then use Conditional Formatting to highlight them
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Then don't have them enabled automatically. When you open Excel, just enable macros. Wasn't aware of the sin I obviously committed by writing that.
If you my posts help you, click the star icon!
Nobody suggested a sin, just bad security advice
Here's a Calendar with reminders
ACADEMIC_CALENDAR(1).xlsm
Last edited by royUK; 01-26-2012 at 04:06 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks