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

Popular posts from this blog

c - Compilation of a code: unkown type name string -

java - Bypassing "final local variable defined in an enclosing type" -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -