Input from userform to cells for dates

[seercoven]

Hi Guys,

Does anyone know how i can input dates into cells using the macro? Currently my macro is inputting text into the cells since i need to use the text to column function. Does anyone know where i get find some samples to actually convert userform information to dates in the worksheet?

[JohnTopley]

DATEVALUE function will convert TEXT dates to numeric dates.

Without a workbook (see above on how to attach a sample workbook ) it is difficult to offer further advice

[Marc L]

Hi,

or maybe just using VBA function CDate …