Calendar Reminders

[Andy66]

Hi all

I would like to set up a button in Excel 2010 that sets a reminder in my outlook calendar.

In my worksheet i have a leave date in Col L and email account state in Col P which calls either 1 month or 3 months from a list in sheet 3 Col M. I would like to add a way that sets a reminder in my Outlook calendar for either one month or three months from the leave date in Col L, probably via a button or when 1 or 3 months is selected in Col P.

Hope that makes sense.

Thank you

 

[Andy66]

Anyone have a solution to this?

Maybe VBA code?

When i say reminder i mean appointment set for one or three months time.