Ordinal Numbers with DatePicker

Italophile · #1 10-28-2023, 08:51 AM

Quote:

Originally Posted by gmaxey

Here is a different version that doesn't absolutely require the exit event.

I'm not sure how providing a more complex solution without any explanation of how it is implemented will be helpful to the OP who, from the comments they have made, seems to already be struggling to understand the solution provided by gmayor.

roger.stern@mail.com · #2 08-21-2024, 10:13 AM

Greg has been super helpful in displaying the ordinal date in the format
"D of MMMM,YYYY" Now I need to change the ordinal disaplay to "MMMM D" and I'm not sure how to modify the code.

This what I've been using as mod_SpecFormatDates See Attachment

roger.stern@mail.com · #3 05-27-2025, 06:06 PM

You've been super helpful in the past. I'm now facing a new and perplexing problem. When I insert a date picker, it works until I save the file. It ceases to function in a saved file. I've tried to save as both a document and template, with and without macro support and the result is the same. One the file is saved, the datepicker ceases to function. Any thoughts?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace all Images with ordinal numbers in multiple files	beginner	Word	0	09-19-2021 02:19 AM
Formatting th at the end of ordinal dates	DBlomgren	Publisher	0	01-23-2016 09:44 AM
How do I code ListBox and DatePicker in UserForm? - Word 2013	ickelly	Word VBA	4	08-05-2015 04:07 PM
Datepicker format	piper7971	Excel	1	07-26-2015 02:29 AM
MergeField Alphabetic Ordinal substitutes _ for Z	khinnenkamp	Mail Merge	1	09-29-2013 07:01 PM