Mar 04 2023 08:56 PM
I'm hoping someone can help me asap.
I'm trying to add a date picker macro in MS 365 Word V16.70 for Mac.
I got in touch with the chat people and they were able to give me the following formula to add to Visual Basic Editor:
In the Visual Basic Editor, on the Insert menu choose Insert > Module. A blank white area will display.
In the blank area, type or paste the following:
Sub AddDatePicker()
Dim objCC As ContentControl
Dim objDate As Date
Set objCC = ActiveDocument.ContentControls _ .Add(wdContentControlDate) objDate = Date objCC.Range.Text = objDate
End Sub
Make sure the blinking cursor is somewhere in your code.
On the Run menu choose Run Sub/UserForm
On the Word menu choose Close and Return to Microsoft Word.
You will see your date picker.
Unfortunately I get the following message:
Compile Error: Syntax Error
The following information replaced the original VBE instruction:
Set objCC = ActiveDocument.ContentControls _ .Add(wdContentControlDate) objDate = Date objCC.Range.Text = objDate
I had no idea that there was this much difference between the Word for Mac and Word for PC 🤦🏼:female_sign: This is sooooooo frustrating.
If anyone could assist I would sincerely appreciate it.
Mar 05 2023 01:58 PM
@JulesAnth See the following page of John Korchok's website
https://www.brandwares.com/bestpractices/2019/08/content-controls-for-macos-cool-code/