Date Seperation

  • Thread starter Thread starter MBlake
  • Start date Start date
M

MBlake

Hi,
I have a userform that allows a user to enter a date. Can anyone advise how
I automatically have the date split into day, month and year on a seperate
worksheet?

Thanks,
Mickey
 
Hi,
Forgot to add that I have the cells in the receiving end formatted to
receive the date and display the day, month etc, (i.e. =A2 then format to
ddd or yyyy. I just need to transfer data from the userform to the
worksheet.

Mickey
 
So do you mean

Worksheets("Sheet1").Range("A1").Value = Textbox1.Text

etc.?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top