Given that you want this to run conditionally, the If construct is
necessary. That said, the date of the day you want `Birthday_Message`to
run is all that`s required...

pseudo code:
If Date() = dteRunDate Then Call Birthday_Message

...where dteRunDate is a module level variable of Type *Date*...

Const dteRunDate As Date = "12/11/2012" '//edit to suit
===


As for the OnTime function:
The default for the *Schedule* arg is *True* and so needs only to be
specified if *False* is preferred.

The online help explains how each arg works. LatestTime is conditional
on Excel`s current mode.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion