I would like excel to remind to before particular dates and not necessarily while the

[juntjoo]

... the file is open. So I guess then at least while my pc is on.

What's the easiest way to accomplish this. I don't know vba but I'm feeling adventurous if this could be a beginner's lesson

[David A Coop]

You won't be able to have Excel remind you to do something whenever you turn on your PC (as you suggested) that's what Outlook Calendar is quite good at. However, you could have an Excel prompt appear as soon as you open Excel.

You will need an Excel macro to achieve this.

Probably the best way is by placing the date and message in your PERSONAL.XLSM file.

If you want the forum to assist, please post some more detailed information.

Regards,

David

[juntjoo]

You won't be able to have Excel remind you to do something whenever you turn on your PC (as you suggested) that's what Outlook Calendar is quite good at. However, you could have an Excel prompt appear as soon as you open Excel.

You will need an Excel macro to achieve this.

Probably the best way is by placing the date and message in your PERSONAL.XLSM file.

If you want the forum to assist, please post some more detailed information.

Regards,

David

Thanks. Okay, so what do I need you know to get started? Should I Google "how to make excel macros" or could I get lost while there is a better way?

[David A Coop]

Sorry for the delay, I've been away for a few days.

I can prepare a simple macro for you, but need more information! Perhaps the best idea is to post an example of what you are trying to achieve.

One column will contain the date, another will contain the reminder message.

I assume you want the message before the day! How long? What about weekends?

Regards,

David



Please remember, your request is clearer if you attach a sample workbook.
- Reply, then Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".