May I suggest an alternative? You want to (a) enter the text and (b) then
use a On_Change macro to enter the date.

How about reversing this: (a) enter the date and (b) have a formula enter
the text. This is so much easier.
If the text goes in B10, then use CTRL+; to enter today's date (static) in
C10 and in B10 use =IF(C100,"Received","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sebby" wrote in message
...
I am trying to create a formula or more likely macro that will enter
today's
date as static if the cell to the left contains the text "received". I
have
very little to no macro experience.

Any suggestions?