Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-18-2022, 07:37 PM
Piet Bourke Piet Bourke is offline How to custom Date Picker CC format with Ordinal and superscript it! Windows 10 How to custom Date Picker CC format with Ordinal and superscript it! Office 2016
Novice
 
Join Date: Aug 2022
Posts: 2
Piet Bourke is on a distinguished road
Default

That code mostly works, except there's a bug that means it ruins all date pickers in the document.

I reordered it slightly:

Code:
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Dim i As Long, j As String, Rng As Range
With ContentControl
  If .Type <> wdContentControlDate Then Exit Sub

  If .Title = "MyDate" Then
    .Type = wdContentControlRichText
  Set Rng = .Range
    For i = 0 To UBound(Split(.Range.Text, " "))
      j = Split(.Range.Text, " ")(i)
      If IsNumeric(j) Then
          With Rng
            .Start = .Start + InStr(ContentControl.Range.Text, j) + Len(j) - 1
            .End = .Start
            .InsertAfter Ordinal(Val(j))
            .Font.Superscript = True
          End With
          
        Exit For
      End If
    Next
    .Type = wdContentControlDate
  End If
End With
End Sub

Last edited by Piet Bourke; 08-18-2022 at 07:49 PM. Reason: Found additional improvements, undo customisation
Reply With Quote
 

Tags
ordinal date superscript



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to custom Date Picker CC format with Ordinal and superscript it! word 2003 date picker nashville Word 16 04-06-2012 04:12 AM
Calculations using values from date picker controls Inkarnate Word 0 06-09-2010 07:16 AM
Word 2007 date and time picker dmcohio Word 2 04-09-2010 04:13 AM
How to custom Date Picker CC format with Ordinal and superscript it! Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM
Date format always interpreted as a formula Butch Jackman Excel 1 02-14-2006 11:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft