excel - Date changing to USA Format from userform -
excel - Date changing to USA Format from userform -
i have userform requires date input , until today hasn't caused issue (used lastly 2 weeks).
when date input posts info staging sheet visible on printable page.
the format worked -
activecell.formular1c1 = textbox4.value
but date beingness 03/11/2014 switching round 11/03/2014.
i tried alter code format date e.g.
activecell.formular1c1 = format(textbox4.value, "dd/mm/yyyy")
but 1 time again date showed 11/03/2014.
does have solution date format error?
thanks al
what avoid problem date formatting is:
with activecell .value = textbox4.text .numberformat = "dd/mm/yyyy" end
like create shown value cell independent how inserted user, long it's date-time value.
p.s. have arbitrarily removed .formular1c1
since inserting value, not formula, there's no point insert textbox value formula property of active cell.
excel vba date excel-vba
Comments
Post a Comment