I forgot to add the code to select the first listentry. You can't delete text in a dropdown with VBA anymore than you can in the document using the mouse. The range must be one of the available items.
What I did was create new dropdowns that use "Select One" as the placeholder text. This is set using the Design Mode and you must ensure that you preserve the Placeholder Text style (if you don't like the grey look then modify the style).
I guess I forgot to add the code because if you used a template to create new documents rather than a document to create new documents then you wouldn't need the ClearFields code at all (or I wouln't think you would).
BTW, I changed one of your CCOnExit Cases to show you how to use "CANCEL" vice CC.Range.Select if the entry is too long.
See the attached file and save it as a template (.dotm extension). When you want a new document create it from the template.
Send me an e-mail (use the feedback link on my website) and I will send you the template file.
Reply With Quote