What this should say is:

Can anyone think of a way in which someone could enter a number in a
TextBox (representing a year, say 2009) and then paste the results into cell
A1 as
January 1 of that year?

"Patrick C. Simonds" wrote in message
...
Can anyone think of a way in which someone could enter a number
(representing a year, say 2009) and then paste the results into cell A1 as
January 1 of that year?