date format changes while transferring data to excel sheet from userform

[spycein]

Hi everyone... in a userform textbox if i enter a date format dd/mm/yy and transfer to excel sheet, it saves as mm/dd/yy.

Kindly help. I need to save the data as origin i.e. dd/mm/yy.

Thanks.

 

[VoG]

Try like this

Range("A1").Value=DateValue(TextBox1.Value)

 

[anand_babu123]

Hi Spycein,

You can make use of month, date and year formula to fix this. While user enters date in userform use these 3 formula to extract the date and finally merge in the excel.

thanks

 

[ParamRay]

Check that the regional settings on your PC aren't set to US format.

Start --> Control Panel --> All Control Panel Items --> Region and Language --> Formats

Once you've adjusted the regional settings, restart Excel and try your UserForm again.

Let me know what happens...

 

[spycein]

Hi gpeacock.. did the same but nothing happened...

 

[spycein]

Hi vog... i did not get that.. could you please explain with an example..
Thanks

 

[spycein]

Hi Anand... did not understand the process.. could you please elaborate with an example...
Thanks alot