Paste year as a specific date
 

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?

Paste year as a specific date
 

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?

Paste year as a specific date
 

Something like this maybe...

Range("A1").Value = DateSerial(TextBox1.Value, 1, 1)

Rick


"Patrick C. Simonds" wrote in message
...
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?

Paste year as a specific date
 

Yes, thank you

"Rick Rothstein (MVP - VB)" wrote in
message ...
Something like this maybe...

Range("A1").Value = DateSerial(TextBox1.Value, 1, 1)

Rick


"Patrick C. Simonds" wrote in message
...
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?