Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

**LUCKY92** · 08-17-2020, 10:53 AM

Hello Friends, i am trying to modify the below code i got somewhere from the web, it works fine but i need it to update date in cell in "dd/mm/yyyy" or "dd/mm/yy" format ...here is my code .........

Private Sub txtDate_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If Len(Me.txtDate.Value) = 8 Then
txtDate.Value = Format(txtDate.Value, "00/00/0000")
ElseIf Len(Me.txtDate.Value) = 6 Then
txtDate.Value = Format(txtDate.Value, "00/00/00")
End If

End Sub

Waiting for your valuabe suggestion..........

**rorya** · 08-17-2020, 10:57 AM

That code doesn't update any cells. Is your textbox linked directly to a cell?

**LUCKY92** · 08-17-2020, 11:23 AM

Thanks for your kind response, actually i am updating value through user form in which one field is date field it paste directly to disire cell but in mm/dd/yyyy format i want it to save in dd/mm/yyyy format

**rorya** · 08-17-2020, 11:44 AM

You didn't answer my question. Is the textbox linked directly to the cell, or are you using code to update the cell?

**LUCKY92** · 08-17-2020, 11:48 AM

I am using code to update the cell

**rorya** · 08-17-2020, 11:52 AM

Then you should wrap the textbox value in the CDate function when you assign it to the cell to convert it to a real date value using your regional settings rather than VBA's US formats.

**LUCKY92** · 08-17-2020, 11:59 AM

Originally Posted by rorya

Then you should wrap the textbox value in the CDate function when you assign it to the cell to convert it to a real date value using your regional settings rather than VBA's US formats.

Could you give an assistant on a vba code i can send you my excel file..

**rorya** · 08-17-2020, 12:00 PM

I don't need the file, I just need the line of code that populates the cell.

**LUCKY92** · 08-17-2020, 09:04 PM

.Cells(irow, 2) = RECEIPT.txtDate.Value

**rorya** · 08-18-2020, 03:36 AM

Change that to:

Please Login or Register  to view this content.

**LUCKY92** · 08-18-2020, 11:53 AM

Thank you so much for your support it works fine, but it storing data in mm-dd-yyy format how to change it to mm-dd-yyyy format

**nigelog** · 08-18-2020, 12:05 PM

try

Please Login or Register  to view this content.

**rorya** · 08-18-2020, 12:11 PM

Change the number format of the cell:

Please Login or Register  to view this content.

Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

LinkBack

Thread Tools

Rate This Thread

Display

Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Re: Update Date Field From User Form in dd/mm/yyyy format instead of mm/dd/yyyy format

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

Convert Date format from Text format reading m/d/yyyy to dd/mm/yyyy

User Form changes date from dd/mm/yyyy to mm/dd/yyyy On Spreadsheet

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Date format of yyyy-mm-dd for field entry in user form

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

[SOLVED] opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Bookmarks

Bookmarks

Posting Permissions