Code to reminder pop message on due date request

[mukeshbaviskar]

Hi friends,
Please suggest me a code to remind me on due date and one day before of my deposit maturity date automatically after opening the file once a day.

For example: If my deposit is mature on 31/01/2014 then the first reminder message should be on 30/01/2014 'Your deposit is mature tomorrow!' and on 31/01/2014 the reminder message should be 'Your deposit is mature today!' respectively and select that deposit due date.

Thanking you in anticipation.

Regards,

Mukesh

[p24leclerc]

try this macro in the "This workbook" section of VBE:

Please Login or Register  to view this content.

Comments are written in columnm T.
It will run every time you open your workbook.

[mukeshbaviskar]

Hi Pierre Leclerc,
Good! It's working fine but some revision is required as follows:

I want to pop up message and not comment in column 't'. Because there is another data in column 't'.(I have modify the code)
I want to select the date after pop up message after clicking on 'ok'.

Please Login or Register  to view this content.

Please do the revision.

Thank you.

Mukesh

[p24leclerc]

what do you mean "you want to select the date"?
Which date?
If the message is not in the same row as the placement, how would you know which one is mature? It wold have to be part of the message box then.

[mukeshbaviskar]

Select date means after clicking on ok button the date of maturity should be select. In short the cell should be activated in which the maturity date is.

In this case I didn't understand which deposit is mature. To know the matured deposit I want to select the maturity date. At present I have to scroll down in due date column to find the mature deposit which I want to avoide.

Thank you.

Mukesh

[p24leclerc]

I would like to help you but I don't understand you requirements.
If you can explained in great details your complete process, I might be able to do something.

[mukeshbaviskar]

There are several deposit entries in the table. Each one mature on different date, in short the due date is different. After opening the file I want to pop up the message of the deposits. Which one is mature tomorrow and which one is mature today. So that I may take necessary action because it's very difficult to remember the due date of each deposit or check it daily. After pop up message the cursor should be on the due date of that particular date.

For example:
deposit 1 is mature on 1/2/14 'the pop up message should be
on 31/01/2014: The deposit is mature tomorrow! (the cursor should be on due date 1/2/2014 after pop up message)
on 1/2/2014: The deposit is mature today! (the cursor should be on due date 1/2/2014 after pop up message)

I think now you will understand my requirement better. Feel free if you need any more explanation.

Thanking you.

Regards,

Mukesh

[p24leclerc]

The way I understand you, the macro will stop at the first deposit to mature either today or tomorrow to give you control to write on that specific cell.What next? The macro has stopped. Will you start it manually after that? If you don't change this cell date, the macro will always return to this deposit saying always the same thing again and again.
I would suggest the macro to write in an empty column and you can filter this column to see only those needing your attention. Or the macro can change the color of that deposit so you can find it easily.
I need further information

[mukeshbaviskar]

Hello p24leclerc,
Ok! Now I understand the limitation of it. Now I think that we should modify it little bit as follow. We should change the color of that particular date to green and red only instead of selecting the date. The message will pop up and change the color of date and after clicking on ok button the macro will run till the last entry of that column. It is not possible to insert a blank column because there is a another data in the file which I cannot change. Otherwise I have to change all other formulas and macros for the changed cell address.

The color of tomorrow should be red and today green.

Is it possible without any problem?

Thanking you.

Mukesh

[p24leclerc]

try this:

Please Login or Register  to view this content.

[mukeshbaviskar]

Good! Now it's working fine. Only I want the text color and not cell color. I have added the pop up message box for it. Please do the final revision to close this thread.

Change the color of text red and green instead of cell fill color.

Please Login or Register  to view this content.

Please tell me the color index 2, 3, 4 for my understanding.Which color does it refer?

Thanking you.

Regards,

Mukesh

[p24leclerc]

Please Login or Register  to view this content.

[mukeshbaviskar]

Hello p24leclerc,
Excellent! Now it's working fine as per my requirement.

Thank you for taking trouble to solve my problem. Thanks for explanation of color index.

Regards,

Mukesh

[mukeshbaviskar]

Today I protected the balancesheet by passward and then the macro is not running as before. I have enable all macros in macro setting. I'm getting error 'due to your security setting the macros are disabled. Reopen the file and then enable macros.'

My passward is 1234

Please check it and give me a solution because I have to protect my balancesheet by passward for security.

Thanking you.

Regards,

Mukesh

[p24leclerc]

Sorry but I have no problem with your workbook on my computer.
All macros are working perfectly after I have entered the password.

[mukeshbaviskar]

Hi p24leclerc,
I have enabled all macros in macro setting but I'm getting error. So please suggest me a macro setting to enable macros in passward protected files.

Thank you.

Mukesh