macros and VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1952671%22%20slang%3D%22en-US%22%3Emacros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1952671%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20calendar%20in%20an%20Excel%20workbook.%20How%20can%20I%20set%20a%20reminder%20when%20a%20date%2Ftime%20approaches%20for%20an%20event%20to%20occur.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EFrank%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1952671%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1953495%22%20slang%3D%22de-DE%22%3ESubject%3A%20macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1953495%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F158878%22%20target%3D%22_blank%22%3E%40Frank%20printer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIn%20order%20to%20get%20a%20reasonable%20answer%20that%20suits%20you%2C%20it%20would%20be%20an%20advantage%20if%20you%20informed%20about%20your%20Excel%20version%20and%2C%20if%20possible%2C%20about%20your%20operating%20system.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20are%20some%20possible%20solutions%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E1.%20A%20simple%20example%20in%20the%20file%20%22Kalendar%22%20without%20VBA.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20It%20depends%20on%20which%20version%20of%20Excel%20you%20have.%3C%2FP%3E%3CP%3EReminder%20function%20in%20Excel%3A%20How%20to%20proceed%3C%2FP%3E%3CP%3EGo%20to%20%22View%22%20in%20the%20menu.%3C%2FP%3E%3CP%3EClick%20the%20Toolbar%2C%20then%20Customize.%3C%2FP%3E%3CP%3EIn%20the%20selection%20list%20go%20to%20%22Categories%22%20and%20then%20%22Extras%22.%3C%2FP%3E%3CP%3ESelect%20%22Create%20Microsoft%20Outlook%20Task%22.%3C%2FP%3E%3CP%3EHold%20down%20the%20mouse%20button%20and%20drag%20this%20command%20into%20your%20Word%20toolbar.%3C%2FP%3E%3CP%3ERelease%20the%20mouse%20button%20and%20close%20this%20window.%3C%2FP%3E%3CP%3EIf%20you%20are%20now%20working%20in%20Word%20or%20Excel%20and%20you%20have%20the%20document%20or%20table%20open%20for%20which%20you%20want%20the%20reminder%2C%20simply%20click%20on%20the%20icon%20previously%20added%20to%20the%20toolbar.%3C%2FP%3E%3CP%3EThe%20%22Create%20task%22%20field%20now%20appears.%20In%20this%20window%2C%20enter%20the%20%22subject%22%2C%20the%20desired%20%22due%20date%22%20which%20you%20can%20simply%20click%20on%20in%20the%20calendar%20sheet%20that%20opens%2C%20%22reminder%22%20and%20%22priority%22.%3C%2FP%3E%3CP%3EClick%20on%20%22Save%20and%20Close%22.%3C%2FP%3E%3CP%3ENow%20Outlook%20will%20remind%20you%20of%20your%20task%20at%20the%20desired%20date!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E3.%20Here%20something%20else%20in%20VBA.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIs%20an%20old%20sheet%20that%20someone%20sent%20me%20from%20a%20website%2C%20etc.%2C%20look%20at%20it%2C%20looks%20interesting.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMight%20maybe%20fit%20your%20needs.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957068%22%20slang%3D%22en-US%22%3EBetreff%3A%20macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Excel%2016%20with%20Windows%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20understand%20your%20directions.%20Could%20you%20be%20a%20little%20clearer%20as%20I'm%20just%20a%20beginner%20with%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EFrank%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a calendar in an Excel workbook. How can I set a reminder when a date/time approaches for an event to occur.

 

Thanks,

Frank

3 Replies

@Frank Drucker 

In order to get a reasonable answer that suits you, it would be an advantage if you informed about your Excel version and, if possible, about your operating system.

 

Here are some possible solutions

 

1. A simple example in the file "Kalendar" without VBA.

 

2. It depends on which version of Excel you have.

Reminder function in Excel: How to proceed

    Go to "View" in the menu.

    Click the Toolbar, then Customize.

    In the selection list go to “Categories” and then “Extras”.

    Select “Create Microsoft Outlook Task”.

    Hold down the mouse button and drag this command into your Word toolbar.

    Release the mouse button and close this window.

If you are now working in Word or Excel and you have the document or table open for which you want the reminder, simply click on the icon previously added to the toolbar.

The "Create task" field now appears. In this window, enter the “subject”, the desired “due date” which you can simply click on in the calendar sheet that opens, “reminder” and “priority”.

Click on “Save and Close”.

Now Outlook will remind you of your task at the desired date!

 

3. Here something else in VBA. Is an old sheet that someone sent me from a website, etc., look at it, looks interesting. Might maybe fit your needs.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

 

@NikolinoDE 

 

I'm using Excel 16 with Windows 10.

 

Don't understand your directions. Could you be a little clearer as I'm just a beginner with VBA.

 

Thanks,

Frank

In some Office versions such as Excel for Web or Online, the VBA options are very limited, to put it mildly.
Office also runs on mac and some also on linux, so the questions.

Hope you have not confused with it, or possibly annoyed.

Did the files I sent you not work? ... or is that not what you want to achieve?

Thank you for your patience and time.

Nikolino
I know I don't know anything (Socrates)