Userform displays saved recorded dates with month and date in reverse order

**chin67326** · 12-21-2015, 03:23 AM

Hi all, what is the best way to force a specific date format on a listbox in a userform?

**chin67326** · 12-21-2015, 08:04 AM

Hi folks, I tried using a separate routine and the event routine as shown below and the first date still displays the reversed formatting

Please Login or Register  to view this content.

**chin67326** · 12-21-2015, 08:34 AM

Hi all, I have managed to solve this and get the date formatting I need. I simply added the below to the end of the listbox's Userform's Initialize routine:

Please Login or Register  to view this content.

Chin is happy

Userform displays saved recorded dates with month and date in reverse order

LinkBack

Thread Tools

Rate This Thread

Display

Userform displays saved recorded dates with month and date in reverse order

Re: Userform displays saved recorded dates with month and date in reverse order

Re: Userform displays saved recorded dates with month and date in reverse order

Thread Information

Users Browsing this Thread

Similar Threads

Entering only the date displays current date with month & year

[SOLVED] Date Day and Month Reverse When Copying Data from a Range To A Table using an Array

Month look up in reverse order

Combobox date list - reverse display order

Dates changing from userform when saved

Cell displays last date of next month.

[SOLVED] Macro behaves differently then when recorded and stuffs dates (or date formats)

Bookmarks

Bookmarks

Posting Permissions