Hi,
Does anyone out there have some VBA code that would automatically force a pop up message to manifest on a person's birthday?
I would like for it to:
1 - Read the birth dates from column labeled "Birth Date" (P15:P70) The names are stored on column "Name" (A15:A70)
2 - Compute his/hers age
3 - Display a message stating: "Wish Joe a happy birthday! He is 27 to day." If the birthday is Today, or "Wish Danielle a happy birthday! She turns 19 on Saturday (or Sunday) if it falls on the weekend.
4 - AND I fear this is the hardest part; Have the message give the user the opportunity to acknowledge the event, say by clicking "Yes" or reset to display again next time the work book opens by say, clicking "Later"
I know this may be child's play for most of you, but it is way over my head, so I 'd appreciate any and all help. So far all I have been able to do is get the Name to change color on the person's birthday :-s
Thanks
ZathroZ
Does anyone out there have some VBA code that would automatically force a pop up message to manifest on a person's birthday?
I would like for it to:
1 - Read the birth dates from column labeled "Birth Date" (P15:P70) The names are stored on column "Name" (A15:A70)
2 - Compute his/hers age
3 - Display a message stating: "Wish Joe a happy birthday! He is 27 to day." If the birthday is Today, or "Wish Danielle a happy birthday! She turns 19 on Saturday (or Sunday) if it falls on the weekend.
4 - AND I fear this is the hardest part; Have the message give the user the opportunity to acknowledge the event, say by clicking "Yes" or reset to display again next time the work book opens by say, clicking "Later"
I know this may be child's play for most of you, but it is way over my head, so I 'd appreciate any and all help. So far all I have been able to do is get the Name to change color on the person's birthday :-s
Thanks
ZathroZ