MsgBox alerts

[Andy the yeti]

I have an excel workbook that at certain key dates (for example on the 5th
Feb and the 10th March etc etc) would like to have Alert Box or MsgBox pop up
by way of a reminder to complete a certain task (this would take the shape of
reviewing another part of the workbook for instance)

Is this possible? I have started by listing all the years dates in one tab
vertically and then writing the alert information in the adjacent cell, then
using a =today() was hoping to link the two together… but have come to a dead
end on how to do this.

Many thanks for any help and I hope this makes some sense…

Andy

[vezerid]

Andy,
although there are several solutions, you can start with Conditional
Formatting.
Select both columns, Format|Conditional Formating...

Use Formula Is (instead of Cell Value Is) And enter the following
formula
=$A1=TODAY()
And choose a format to highlight the cells to taste.

On the automation front, as a first step you can put an event macro

Private Sub Workbook_Open()
Sheets("Unfinished Tasks").Activate
End Sub

This will be activated any time you open the workbook and bring up the
specified sheet.
To install:
1. Change the part within the quotes to the name of the sheet.
2. Alt+F11 for the VBA development environment
3. At the top-left of the window you see the Project Explorer window.
Double-click on the ThisWorkbook icon.
4. Paste the code. From this point on, every time you open the workbook
it will take you to the task list first.

Maybe you can have an additional column with a 0/1 or yes/no if the
task is completed. If you put this in column C:C then the formula for
conditional formatting would be:

=AND($A1=TODAY(), $C1=0)
or
=AND($A1=TODAY(), $C1="no")

HTH
Kostis Vezerides