macros and VBA

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.