Resting Anchor

The Anchorage

Personal website of Gregory K. Maxey, Commander USN (Retired)

What's New

Share

Here you'll find links to new pages, links to changed pages, and notification of deleted pages.

Friday, 24 November 2017
Published Import Excel List into Word Dropdown List. This page provides an explanation and examples for populating Word dropdown lists with the content of an Excel column and populating dependent fields with associated data.
Friday, 17 November 2017
Updated Conditional Header (and/or Footer) Text to show how to color code conditional header/footer text.
Wednesday, 09 August 2017
Published File New (Enhanced) Interface for Word 2013-2016 Version 1.0. This provides an enhanced Backstage user interface for create new documents from your templates or recenty used templates.
Saturday, 11 February 2017
Published Spell Out Currency Version 4.3. This version enhances output format flexibility and corrects a minor bug.  Note - Changes were only made to the .dotm version of the Add-In.  I am no longer supporting the .dot version.
Sunday, 18 December 2016
Published Trim Cell Text in my VBA Nuggets tips page. Provides a VBA solution to trim leading and trailing space from table cell text.
Tuesday, 13 December 2016
Published AutoTextList in the Modern Age.  Describes AutoTextLists and provides a VBA method to quickly create and employ them.
Monday, 12 December 2016
Published VBA Nuggets.  A VBA nugget is simply a decryption of a problem or issue and a VBA solution to solve it.  Typically too short to warrant its own dedicated tips page.
Sunday, 11 December 2016
Published update to Customize Shortcut Menu. Removed links to MVPS Word FAQ website soon to be terminated.  Added two VBA methods to apply custom graphic files to a CommandBar button face.
Sunday, 04 December 2016
To the dismay of many, the administrators at mvps.org announced recently that they would be terminating hosting services for this website and many others (including the Word FAQ site) on 28 January, 2017.  Accordingly, I am now publishing the content of this site at gregmaxey.com.  In the interim, published links to gregmaxey.mvps.org content will be redirected to matching content at the gregmaxey.com domain.  After that date ... who knows?  If you have saved links to my content at gregmaxey.mvps.org, then please update those links to gregmaxey.com.

This site contained over 60 links to content at the Word FAQ website.  At this date, there is no clear plan by the MVPs for continuing that content with another hosting service.  Some of the MVPs are moving the articles they wrote or collaborated on to their own personal sites.

I have began the process of either removing or updating links to mvps.org content on this site to alternate existing content , content moved to individual MVP sites e.g., Suzanne Barnhill's Non-Printing Characters, or new content published on this site e.g., Early vs. Late Binding
Friday, 02 December 2016
Published version 3.1 of my Content Control Tools template add-in. This version corrects a code error in the InstaMap process.
Saturday, 06 August 2016
Published version 3.3 of my Extract Data from Forms template add-in. Excludes Access as a target data storage file when the form field count exceeds 255.
Saturday, 18 July 2016
Published version 3.2 of my Extract Data from Forms template add-in. Resolves an issue when attempting to extract  data exceeding 255 characters to Excel.
Saturday, 09 July 2016
Published version 3.1 of my Extract Data from Forms template add-in. Right on the heals of version 3.0, version 3.1 shifts the emphasis from tagging (to process) content controls purposed for form data fields to tagging (to filter and exclude) content controls that perform other roles (e.g., a rich text control used to group boiler plate text and form data fields).
Published version 3.0 of my Content Control Tools template add-in.  This version incorporates the two new  utilities developed in Extract Data from Forms.
Wednesday, 06 July 2016
Published version 3.0 of my Extract Data from Forms template add-in. The update improves the data extraction to the Excel target, updates the Title/Tag Form Data Fields to include formfields, and includes a new utility to convert formfields to content controls.
Wednesday, 25 May 2016
Published an  updated template add-in to restore AutoCorrect to the Word 2016 Spelling right click Context menu in my Customize Shortcut Menus tips page.  This was done to fix a bug introduced by a recent update to Word.
Sunday, 2 April 2016
Published Content Control Tools Ver. 2.6. This version allows you to skip individual or skip all untitled content controls when using the InstaMap feature to map content controls and copies the content control ID information to the clipboard when you click the ID information label.
Thursday, 3 September 2015
Published minor update to Date Picker (Calendar) Form.  After some last minute testing it seems I left the default calendar initializing with the maximum date 12/31/2915.  Fixed now!
Sunday, 30 August 2015
Published Date Picker (Calendar) Form.  Based on CalendarForm developed by Trevor Eyre, provides a compact self-contained userform that can be employed as a DatePicker and replace Microsoft's defunct DTPicker control in VBA userforms or used as a calendar in Word.
Tuesday, 18 August 2015
Published Word Address Book.  Based conceptually on a similar Word Address book published by Word MVP Graham Mayor, this version uses document CustomXMLParts.  It is self contained and, except for importing utilities, it can function independent of Excel or other data source files.
Sunday, 05 July 2015
Published update to Content Controls and a white paper on comingling content control and legacy formfields in a document.
Saturday, 13 June 2015
Published updates to Content Control Tools and Content Controls - Do Not Print Placeholder Text (PHT) to address user feedback on the procedures for suppressing PHT in printed documents.
Wednesday, 03 June 2015
Published updates to Content Controls and Validate Content Control Entries to correct information related to the Word 2007 ContentControlOnExit Event bug and provide an alternate workaround solution.  These updates are the result of feedback from a web visitor.
Tuesday, 25 March 2015
Published an update to Toggle Data Display.  This update provides a method to toggle the display (show/hide) document text using mapped content controls and the document (Word 2007 and above) CustomXMLPart.
Saturday, 14 March 2015
Published a major revision to Building Blocks & AutoText. Revision includes a completely redesigned Building Blocks Word Template Add-In.  The former Building Blocks Enhanced Tools Add-In is no longer published or supported on this website.
Published Content Control Tools Version 2.1. Version 2.1 improves the layout of the InstaMap page tab and adds the ability to copy the XPath of a mapped content control to the clipboard.
Tuesday, 10 March 2015
Published Link "Conditional Content" to a List Selection.  Consolidates and supersedes my "Link FormField Dropdown Lists" and "Link Content Control Dropdown List" tip pages.  Expands on those methods and provides methods when using ActiveX controls or a Userform.
Tuesday, 03 March 2015
Published Content Control Tools Ver. 2.0.  This version add the ability to automatically flag mapped content controls as editable regions in document with "Editing restrictions - No changes (Read only).
Monday, 09 February 2015
Published version 2.4 of  Batch Process Documents to correct a bug in the process of saving processed files.
Friday, 06 February 2015
Published AutoCorrect Utility Manager which provides a convenient utility to add/redefine/delete/backup/restore/transfer AutoCorrect entries.
Saturday, 15 November 2014
Published Extract Outlook Data Ver. 1.2 to addressed an issue that could result in transposed days and months when reading European format dates into an Excel worksheet.
Friday, 14 November 2014
Published Content Control Tools Ver. 1.7 This update fixes a bug that prevented the add-in form deleting some locked content controls.
Wednesday, 05 November 2014
Published Content Controls Tool Ver. 1.6 This update fixes a bug that prevented plain text controls containing multiple lines of text from being mapped.
Tuesday, 04 November 2014
Published version 2.3 to Word Usage & Frequency Report. This update fixed a bug when using some other regional language settings. 
Sunday, 02 November 2014
Published Content Controls Tool Ver. 1.5 This update provides the option to exclude content controls already mapped to a built-in CustomXMLPart when using InstaMap. 
Friday, 17 October 2014
Published minor bug fixes to Content Controls Tools and Batch Process Documents template add-ins.  Download the updated versions from the download link on the applicable tips page. 
Sunday, 5 October 2014
Published Extract Data from Outlook E-mail Messages.  Co-developed with friend and frequent collaborator Graham Mayor, this add-in can be employed to extract data from e-mail messages to Access, Excel or Word. 
Tuesday, 2 September 2014
Published version 2.2 of Batch Process Documents to correct a bug in the create log process.  Corrected a invalid link in Extract Data from Forms.
Sunday, 17 August 2014
Graham and I have been rather bored during the "heat" season in central Florida and his fair island Cyprus.  While I've been buried in a soon to be released add-in to extract data from Outlook, Graham, has addressed a few bugs in our Batch Process Documents add-in and added four new pre-defined processes..
Tuesday, 12 August 2014
Published Extract Data from Forms Add-in.  This project represents a major revision to my earlier "Extract Content Control Data from Forms" and adds the ability to extract data from legacy form fields.
Thursday, 7 August 2014
Published Batch Process Documents Ver 2.0.  A collaborative effort with Word MVP and old friend Graham Mayor.  This version represents a major revision to my earlier work and provides a easy to use single Word template add-in that you can use to perform several useful built-in procedures on a batch of documents, or process a batch of documents using your own custom VBA procedure.
Monday, 14 July 2014
Published version 1.3.1 to Content Control Tools.  This version refines handling of the Word built-in user notification dialog if you attempt to insert a mapped content control at an invalid selection.
Wednesday, 9 July 2014
Published version 1.3 to Content Control Tools.  This version corrects an error that occurred if you tried to create, nest and mapped a rich text content control in another mapped parent rich text control.  Code changes allow you to create and map contents controls with selected content and improves error handling if you attempt to create a control at a restricted location.
Saturday, 5 July 2014
Published version 1.2 to Content Control Tools.  This version corrects an error that occurred if you tried to populate a mapped dropdown list or combobox content control using an external Excel list and adds the ability to map each content control to its own unique node using the InstaMap feature.
Friday, 20 June 2014
Published version 1.1 to Content Control Tools.  This version allows you to suppress printing content control placeholder text and fixes several bugs detected in the project.
Monday, 9 June 2014
Published Content Control Tools.  A massive project that combines and consolidates useful content control tools from some of my earlier projects plus lots of useful new features!
Thursday, 15 May 2014
Published updates to the Number To Currency As Text add-in featured in my Spell Out Currency tips page. Expanded targeted output capability, improved compatibility with Word 2013, and resolved issues with regional thousands separator and decimal point characters that are reversed or different for the U.S. system. This add-in is a parallel project with long time friend and collaborator Graham Mayor.  Graham has slightly different version of the add-in on his site Display Currency Value in Words.
Friday, 11 April 2014
Published Content Control Pronoun Sets. A Word template add-in you can use to create and manage content control personal pronoun sets.
Thursday, 6 March 2014
Revised and updated: Extract Numbers from Truncated Strings. Added simplified method which employs the VBA "Filter" function suggested by user feedback.
Thursday, 26 February 2014
Revised and updated Modify/Customize QAT Icons, Labels and add Supertip.  Added method for adding supertip text to QAT controls and custom icons.
Tuesday, 28 January 2014
Published Change Ribbon Icon & Font Size.  Simple steps you can take to change the size of your ribbon icons and fonts without changing screen resolution.
Monday, 27 January 2014
Published version 1.2 to my ADCAP Content Control Check Boxes and Option Buttons.  This version provides enhanced features for selecting and defining state symbols.
Tuesday, 21 January 2014
Published update to Create and Employ a Userform.  Update provides a functional example of a content control centric userform and document template.
Monday, 30 December 2013
Published ADCAP Content Control Check Boxes and Option Buttons which provides a method for creating and employing one or more groups of mutually exclusive content control option buttons in your documents.
Sunday, 29 December 2013
Updated the Word Usage & Frequency Add-In to make it compatible with Office 64-bit versions.
Friday, 21 November 2013
Published Content Control ADCAP (Advanced Capability) Dropdown Lists.   When the U.S. Navy retrofitted and improved the MK 48 heavy weight submarine launched torpedo in the 1980's the designation for this much improved weapon was MK 48 ADCAP.  ADCAP being an acronym for Advanced Capability.
In a throwback to my Navy days, I decided to use the same acronym to describe the techniques demonstrated in this tips page.  Employing them certainty advances the capabilities of the basic controls!
Tuesday, 22 October 2013
Published Word 2013 Table Layout Change.  Microsoft introduced a new layout engine with Word 2013.  This resulted in a change in the default layout of tables you insert in Word 2013 documents.  This tips page describes this change and offers a couple of VBA solutions for restoring the previous layout or using the new layout with tables from earlier Word versions.
Friday, 27 September 2013
Published "Hangman for Word" (A Class Study).  Hangman for Word is a Word template add-in containing the popular word game "Hangman."  The page provides a tutorial to assist the novice VBA developer explore and understand class modules plus some advanced userform techniques.
Sunday, 21 July 2013
In response to feedback from friend and Word MVP Doug Robbins, I've updated the methods for displaying dual numbering in a Word document.  See:  Page Numbering
Thursday, 14 June 2013
Published Content Control Help Text.  Collaborating with MVP Jay Freedman, this tips page illustrates several methods for creating and displaying custom Content Control user Help Text.
Sunday, 02 June 2013
Published version 4.0 of CC⁄V⁄BM & DP Tools Add-in  This is version makes the add-in compatible with the Office Word 64 bit application.
Monday, 27 May 2013
Published Populate UserForm ListBox & ComboBox w\Advanced Functions.  This is an enhancement of my popular Populate Userform ListBox or ComboBox tips page.
Saturday, 23 February 2013
Published Version 2.0 to Word Usage & Frequency.  This is a major revision and enhancement of a popular add-in.
Sunday, 10 February 2013
Published "Number to Currency as Text" Word Template Add-In as an update to my popular "Spell Out Currency" tips page.  "Number to Currency as Text," co-developed with Word MVP Graham Mayor, is a full featured template add-in that you can use to insert currency values as text in a broad range of currency units and formats.
Sunday, 27 January 2013
Updated Modify QAT\Ribbon Button Icon\Text to demonstrate how you can apply the full range of available imageMso attributes to custom ribbon icons.
Saturday, 26 January 2013
Based on user feedback, I've learned of some problems encountered when using the simple ASCII character values for symbol pairs in my Toggle Objects add-in.  I've update the tips page and add-in to include the use of Unicode values where required.
Wednesday, 26 December 2012
With the New Year nigh upon us, I've decide to dust off and revamp my Perpetual Calendar Maker Add-In.  The new version now includes "mini" last and next month calendars on the monthly landscape calendar, an empty picture content control on the monthly portrait calendar that you can use to add you favorite image file, Julian date on the annual 12 month calendar, and a perpetual Julian calendar.
Sunday, 16 December 2012
Resurrected  Add Filename and Path to Application Title Bar.  This tips page was omitted when I revised the website in January 2012.  I've resurrected it due to a recent question in a popular Word support forum.
Monday, 10 December 2012
Published Tinkering with CustomXMLParts.  This tips page provides three different techniques which I have discovered while "tinkering" with CustomXMLParts.  This work have giving me a better understanding of how CustomXMLParts work and how I can leverage them in document solutions.  Hopefully you will find them useful also!
Saturday, 1 December 2012
Published CustomXML "Helpful" Help for Word.  Intended to spare the novice to intermediate Word user the angst and frustration attempting to understand and employ CustomXMLParts using Microsoft's less than "helpful" help files, this tips page includes a document and supporting files that provides "functional" examples.
Wednesday, 13 November 2012
Published List All Keyboard Shortcuts Using the macro provided in this tips page, you can easily create a complete composite list of all Word keyboard shortcuts.
Monday, 22 October 2012
Published Convert Fixed Notes to Dynamic Footnotes/Endnotes. Using the macro provided in this tips page, you can easily convert fixed reference text appear at the of the document into dynamic footnotes.
Friday, 19 October 2012
Published Word's Fickle VBA Find Property.  This is another tips page that I've planned to write for sometime but never got around to it.  If you are new to Word VBA and trying to get your head around how to use the .Find property; or if, like me, you've ever pulled out clumps of hair and scalp in frustration trying to use it, then this tips page might help.
Monday, 08 October 2012
Published UserForm Advanced Notes & Tips.  A long time in the works, this tips page consists of a collection of my notes and demonstration forms which attempts to explain my understanding of some of the advanced concepts and features associated with userforms. 
Tuesday, 02 October 2012
Published Repeating Item Lists.  Inspired by a recent topic in a VBA support forum, this tips page demonstrates several methods for creating a user defined repeating item list.  Such as a list of books, list of children, etc., where each listed item has multiple descriptive properties.
Monday, 26 September 2012
Published Create Forms with Content Controls.  Intrigued by my discoveries while researching Extract Content Control Form Data, I have put together this tips page which summarizes methods, advantages and disadvantages of using content controls in restricted content online, protected, fill-in and electronic "e" type forms.
Saturday, 24 September 2012
Published Extract Content Control Form Data.  Expanding on my earlier published methods for extracting form data and inspired by recent tinkering's of friend and frequent collaborator Graham Mayor, Extract Content Control Form Data is a full featured Word template add-in that you can use to gather and record data presented in content control forms.
Saturday, 15 September 2012
Published Classic WordArt in Word 2010/2013.  This tips page discusses some of the peculiarities users may experience when working with "classic" WordArt in Word 2010/2013.  It also contains a few observations on "new" WordArt.
Monday, 3 September 2012
Published Add Table Row with Content.  This tips page provides a macro solution to insert or append table rows with content.
Thursday, 30 August 2012
Published version 3.2 of "Content Control/Variable/Bookmark and Document Property Tools" Add-In.  As expected, version 3.0 is showing growing pains and several of these were exposed while creating the companion tips page Add, Map and Employ Repeating Section Content Control in Word 2013. Additionally, Graham Mayor is back on the scene and has made a few suggestions for improvements.
Thursday, 16 August 2012
Published Add, Map and Employ Repeating Section Content Control in Word 2013.   This tips page demonstrates how you can add, map and employ repeating section content controls in your Word 2013 documents using my Content Control/Variable/Bookmark and Document Property Tools Word template add-in.
Tuesday, 14 August 2012
Published version 3.0 of "Content Control/Variable/Bookmark and Document Property Tools" Add-In.  Version 3.0 represents a significant change from version 2.2.  It introduces a new content control mapping process and provides tools for mapping rich text controls and the new repeating section content controls in Word 2013.  
Thursday, 27 July 2012
Published Content Control Enhancements - Word 2013.  This Microsoft Word Help & Tips page provides a summary of the enhancements make to content controls in Word 2013, with working demonstrations.  
Saturday, 21 July 2012
Published an update to Photo Gallery Add-In for Word 2007/2010. Version 1.2 resolves some minor bugs, adds a confirmation warning to the "Delete" image feature and provides improved format painting.  
Monday, 16 July 2012
Published Photo Gallery Add-In for Word 2007/2010. Inspired by friend and Word MVP Graham Mayor, this add-in simplifies creating photo galleries in your Word documents. 
Saturday, 19 May 2012
Published version 2.1 of my VBA Find and Replace© add-in. This version corrects an error processing Word 2010 drawing canvass shapes and resolves an issue were a paragraph mark was inserted in previously empty headers and footers. 
Thursday, 23 February 2012
Published:  Content Controls - Do Not Print Placeholder Text.  This Microsoft Word Help & Tips page is a collaborative effort with MVP Jay Freedman. It provides three VBA methods to prevent printing the visible placeholder text in uncompleted content controls. 
Sunday, 19 February 2012
Consummatum est!! After nearly six grueling weeks the website is now completely updated and weaned of any reliance on FrontPage Server Extensions.  During the conversion process, I eliminated the following pages:  Add File Name and Path to Document Title Bar, Word Limits and Delete Text to End of Line.  I have added my own tips page providing instructions for installing and using VBA procedures or add-ins contained on this site Install/Employ VBA Procedures (Macros) and Calendar Maker Add-In which provides a simple template add-in for creating perpetual calendars. 
Monday, 06 February 2012
ContructionStill plowing through the conversion of the tips pages. I suppose I am about 50% complete and I'm trying to knock out a couple each day. Today I deleted, "Delete Text to End of Line" after discovering that the basic functionality is already built-in to the smart cut and paste options.
Thursday, 19 January 2012
For the last two weeks I've been taking a crash course in web design.  Notified on New Year's Eve that my hosting service would be eliminating Front Page Server Extensions support later in the spring, I decided it was time to wean the site of that requirement and give it a face lift.  Today I published the basic foundation pages of the new site along with a few of the redesigned tips pages.  Updating all of the Microsoft Word Help & Tips pages may take several months, so most are still in the old format. I will be updating them as time permits. I will not list each reformatted page here unless there is a significant change in content.
Monday, 7 November 2011
Almost two months ago I came across the question in a Word support forum, "How do I select all the text in a Word sentence?" The problem is that Word on its own has a tough time determining what a sentence really is. After several months and many hours of testing and hard-work, I am pleased to publish:  Deduced Sentences. Deduced Sentences is a Word template add-in with a new "Sentences" class co-developed with Jason Simpson. Using the add-in you can perform function involving sentences with a much higher probability of getting the sentence definition right!
Tuesday, 20 September 2011
Over the years, and due to "quick" changes and modifications, my VBA Find and Replace Add-In had grown a bit unwieldy. I have overhauled the underlying code and given the add-in a facelift in hope of making it easier to use. It is now published as version 2.0.
Saturday, 17 September 2011
Published Version 2.2:  Mayor & Maxey "CC/V/B and DP Tools" Add-In to correct an apparent bug in the list content controls function when using Word 2007.
Thursday, 08 September 2011
Published version 2.0 of:  Invoice (Interactive w\Auto-Table Calculate. Version 2.0 corrects numerous formatting errors, provides the ability to add "stamps" to completed invoices and incorporates several suggestions for improvements offered by users.
Tuesday, 30 August 2011
Published:  Invoice (Interactive w\Auto-Table Calculate). This is another "child" of previous projects. Here, I have incorporated custom Table Cell Events into an interactive Word invoice template co-created early last year with Word MVP and long-time friend Graham Mayor. The original template is currently available on Graham's website:  Interactive Invoice Template
Saturday, 27 August 2011
Published:  Table Cell Events.  A brain child of the Content Control OnChange event introduced last month, this add-in provides a VBA method to monitor and detect OnEnter, OnExit and OnChange events in Word table cells.
Wednesday, 28 July 2011
In collaboration with Jeff Vandervoort, a regular contributor in the Office Word for Developer forum, I have created and published a VBA method to monitor and evaluate custom content control events. The custom events provide a reliable means to monitor content control OnEnter and OnExit events, and monitor the content control range for any change, which will trigger a custom "OnChange" event: Content Control Custom Events
Saturday, 25 June 2011
Published an update to:  Build & Deploy Custom Building Block Gallery following feedback suggesting that the add-in include features for selecting the template to process and add Building Block descriptive text.
Sunday, 05 June 2011
Published:  Insert Content with Content Controls. This tips page compliments Graham Mayor's Insert content from a form field and provides several examples for placing content in your document using a content control.
Friday, 25 February 2011
After much wailing and gnashing of teeth, I have resolved the issue of the LoadPictureGDI function failing to load *.png format graphic image files in the Word 2010 ribbon:  Ribbon Images & Labels: Part III.
Saturday, 12 February 2011
Updated and renamed:  Extract Form Field/Content Control Data. Added code to extract data from document content controls. Added information for working with ".accdb" format Access database files.
Wednesday, 09 February 2011
Published:  Math Operations using Content Controls. Tips and examples for using content controls as variables and to display results of mathematical operations.
Update Content Controls.
Tuesday, 08 February 2011
Published:  Content Controls. A new tips page that provides an introduction to content controls and links to all of my tips focused on content controls.
Friday, 04 February 2011
Published:  Linked Content Control Drop-Down List. A new tips page provided to illustrate how to create a pair of linked content control drop-down lists. The user selection in the primary control determines the list items in the dependent (secondary) control.
Thursday, 03 February 2011
Publish Version 1.7 to:  Mayor & Maxey "CC/V/B and DP Tools" Add-In
This version of the add-in introduces changes in the code used to evaluate the Word application version following feedback from a person that uses the French language version of Office 2007.
Tuesday, 01 February 2011
Publish Version 1.6 to:  Mayor & Maxey "CC/V/B and DP Tools" Add-In
This corrects a minor bug introduced with Version 1.3.
Sunday, 30 January 2011
Publish Version 1.5 to:  Mayor & Maxey "CC/V/B and DP Tools" Add-In
This version corrects a minor bug introduced with Version 1.4 and enhances the process for reviewing individual content control XML node values.
Friday, 28 January 2011
Publish Version 1.4 to:  Mayor & Maxey "CC/V/B and DP Tools" Add-In
This version significantly improves the process for reviewing and deleting the content control XML mapping nodes. It also adds the ability to map a qualified content control that you have selected in the document. Several additional display enhancements were also performed. Be sure to download and start using the latest version!!
Thursday, 27 January 2011
Published bug resolution in:  Mayor & Maxey "CC/V/B and DP Tools" Add-In
Monday, 24 January 2011
Developed in collaboration with long-time friend and Word MVP Graham Mayor we provided a convenient add-in to unleash the usefulness and availability of mapped content controls and variables (the "Hidden Gems") of Word documents: Mayor & Maxey "CC/V/B and DP Tools" Add-In
Thursday, 30 December 2010
Developed in collaboration with long-time friend and Word MVP Graham Mayor, we provided a convenient add-in for managing document variables.
Tuesday, 30 March 2010
Based on a suggestion from long-time friend and Word MVP Graham Mayor, I have added a utility to my Classic Form Controls add-in that simplifies adding, deleting, or editing dropdown list entries.
Sunday, 28 February 2010
Added a simple procedure for converting common fractions to my Formatted Fractions Microsoft Word Help & Tips page. I have used this page to introduce a new "html content" feature in my tips pages for displaying VBA code.
Friday, 26 February 2010
Added examples and code to the Populate Userform ListBox page that illustrates hiding multiply column data and selectively using column data.
Monday, 22 February 2010
After putting if off for over a year, I decided to compile some of my notes on VBA and post them as a Tips page:  VBA Basics
Monday, 15 February 2010
Added Microsoft Word Help & Tips page Content Control Grouping and Navigation. Having stumbled on a technique for navigating (tabbing) from one rich text content control to another, I thought I would write it up and publish it here.
Friday, 05 February 2010
Added a link on my Word Help & Tips page (Go to link) to an automated interactive Word Invoice template posted by friend and Word MVP Graham Mayor.
Wednesday, 03 February 2010
Pinged by friend and Word MVP Graham Mayor for the oversight, I have added a zip file containing a complete Word template add-in for displaying Classic Form Controls on the Word 2007 ribbon to my Classics Form Controls tips page.
Thursday, 7 January 2010
Published a revision to:  VBA Find and Replace.  The revision adds a recursive sub-routine that processes grouped shapes, shapes in a canvass, and grouped shapes in a canvass located in a header and footer.  Thanks to Mark Rozenberg of Moscow, Russia for notifying me of this shortcoming and suggesting the recursive sub-routine.
Friday, 6 November 2009
Added new Microsoft Word Help & Tips page Content Control Validation using an attached Schema
This tips page demonstrates the ability and steps necessary to validate data entered into a mapped content control against an attached schema.
Thursday, 5 November 2009
Updated and renamed my Microsoft Word Help & Tips page "Sort List and Remove Duplicates" to:
Sorting Lists (Macro methods) after adding a few additional macros. You can use these macros to:
1) Sort and remove duplicates, 2) Exclude the articles "A" and "The" from sort criteria, and 3) Relocate articles "A" and "The" in list members.
Wednesday, 4 November 2009
Added some notes and additional code to Microsoft Word Help & Tips page Interactive Userforms to check that referenced bookmarks exist before attempting to read from or write to their respective ranges. Updated the downloadable document that contains example code.
Added a new Microsoft Word Help & Tips page Line Numbering which shows you how to employ the section direction option and a right-to-left script language, such as Hebrew or Arabic, to display line numbering in the right margin.
Saturday, 24 October 2009
Added a Microsoft Word Help & Tips page Interactive Userforms to supplement my Create and Employ a Userform page. This page provides examples and code for making data in a document interactive with corresponding data controls in a Userform.
Friday, 23 October 2009
Made minor corrections to my Modify CC Placeholder Text tips page and added a template add-in that you can download and use to speed up the process of reviewing and setting Content Control properties.
Added a few new vintage Navy recruiting posters to the Word Tips page.
Thursday, 22 October 2009
Added this What's New page to help regular visitors to this site access changes and new material.
Wednesday, 21 October 2009
In collaboration with MVP Cindy Meister, I have published and explained a process for extracting individual numbers from a user input of continuous, discontinuous, and group continuous numbers: Extract Numbers from User Input String

PAYMENTS/DONATIONS

Click to acces PayPal Verification Service Click to acces PayPal Verification Service

Do you want to make a payment for consulting work or donate to help support this site?

PayPal is a safe, easy way to pay online.

Use the appropriate currency "Donate" button to make a payment or donation.


Search my site or the web using Google Search Engine

Google Search Logo