How do I convert Dates from Text back to Date format using macros

F

Frank Kabel

Hi
tryx something like

with activesheet.range("A1:A100")
..numberformat="MM/DD/YYYY"
..value=.value
end with
-----Original Message-----
My dates seem to be storing as text when being written
Click to expand...
from a user form... Is there any way to convert these
programmatically??? If I manually convert text to columns
and select date.. it shows correctly and will sort
properly.. VBA doesn't seem to be carrying the formatting
style back from the user form even though it is specified
as format(..., ""MMM-DD-YY") because when it sorts.. it
as though it is text not a date... How can I get it back
to date format???? The user will not know how to do this
so.. I need to somehow do it in a macro or in vba. The
data is dynamic.
 
Top