#1
|
|||
|
|||
Clear Button For Specific Content Control
Hello,
How can I make a button to clear some content control, but not everything. I am creating a form that can be reuse next year with some information changes every year while some initial input stays the same. Example, I have Content Control Tag/Title Name, DOB, Product, Price If I press the "clear button" Product and Price would clear, but Name and DOB will not be clear and stay as is it written Thank You |
#2
|
||||
|
||||
I would use a consistent Tag value in each CC that needs to be wiped by the macro. For example, set the Tag property to "Annual" for the plain text CCs you want to wipe.
The macro that then wipes those ones (at its simplest) would be Code:
Sub DeciduousCCs() Dim aCC As ContentControl For Each aCC In ActiveDocument.SelectContentControlsByTag("Annual") aCC.Range.Text = "" Next aCC End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
I tried using the code given, but I couldn't figure out how to use it.
But I have of thought of something but I do not know how to code it. Say I have Content Control Title: Price and Product, both Tags "Annual" (assuming these values changes every year and other tags don't) Maybe by using a event on exit I add a rich text cc TAG: Clear If I Select the field with the Clear Tag (On entry) then exit the field (On Exit) Tags with "Annual" would clear |
#4
|
||||
|
||||
Post an example document with some tagged CCs and I will test the macro on that to see where you are going wrong.
I wouldn't recommend the on exit macro. That seems too easy to trigger and likely to cause data loss when you don't intend it.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
Here is my sample document.
Fields with tag annual in that document are just few of many. So ideally I want the fields with the annual tag to be cleared out once for it not to be confusing to the user with the new values(this year) and old values(last year), instead of having the fields be cleared only when clicked/selected |
#6
|
||||
|
||||
The easiest way to use the macro is to add a MacroButton Field below the table. You then run the macro by double clicking that text. To do this:
1. Stop the Protection 2. Put your cursor immediately below the table and paste the following line of text MacroButton DeciduousCCs Double Click to clear Annual fields 3. Select that text, change its colour so it stands out (eg Red) and press Ctrl+F9, then press F9 to hide the field code. 4. Reprotect the document 5. Make sure the macro is sitting in a module in the document and that macros are enabled.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#7
|
|||
|
|||
I modified the line
Code:
aCC.Range.Text = "" Code:
aCC.Range.Delete But this works perfectly, Thank You! |
Tags |
clearcontents, content control, vba |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help to get a word document to send specific content via email using submit button | ActualJax | Word VBA | 2 | 07-06-2020 04:18 PM |
Finding specific Content Control based on both title and tag | ZaSpai | Word VBA | 4 | 03-31-2019 11:37 AM |
Adding Row with Content control using Command Button | baes10 | Word VBA | 0 | 12-13-2017 11:30 AM |
Content Control Option Button Oops | warbird | Word VBA | 5 | 12-07-2017 06:53 AM |
Code to Sum Column of Content Control Values In Specific Tables? | warbird | Word VBA | 2 | 07-13-2015 05:44 AM |