Start macro when placeholder gets focus

PellePetimeter · #1 03-14-2017, 10:31 AM

I want to create a macro that starts when a placeholder gets focus or gets changed. I have googled it but found nothing. Isn't this possible?

We use Word 2016.

macropod · #2 03-14-2017, 07:32 PM

That's quite easy if your placeholder is a formfield (in a document with forms protection), content control or ActiveX control serving as the placeholder, but not otherwise. What is your placeholder?

PellePetimeter · #3 03-15-2017, 01:41 AM

It is at content control.

macropod · #4 03-15-2017, 05:26 AM

In that case, you'd use a Document_ContentControlOnEnter macro to the Document's 'ThisDocument' code module. The skeletal structure is:

Code:

Private Sub Document_ContentControlOnEnter(ByVal ContentControl As ContentControl)

End Sub

PellePetimeter · #5 03-16-2017, 01:50 AM

It works, thanks!
But this macro starts each time any content control gets focus. So I need to either change the code so it just starts when a specific content control is marked or do something like:

Code:

Private Sub Document_ContentControlOnEnter(ByVal CC As ContentControl)
If CC.Title like "Leder" Then doSomeThing
End Sub

It's been i while since I worked with macros so it's not stright forward to me, but I'll figuere it out.

macropod · #6 03-16-2017, 04:26 AM

Yes, if you want to restrict the response to one or more content controls, you need to specify which one(s) to act on or to exclude. That can be done via the content control's Title and/or Tag, or its relative position in a defined range (i.e. Document, Section, Table, etc.).

There are plenty of examples of that on this forum, though usually in the context of a ContentControlOnExit macro. A search for 'ContentControl' will turn up numerous examples.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to move focus after entry in a cell	Phil H	Excel Programming	3	06-18-2015 01:20 PM
difference between scheduled start and start	ketanco	Project	3	01-15-2015 07:53 AM
SlideMaster: Date Placeholder, Footer Placeholder, Slide Number Placeholder?	tinfanide	PowerPoint	1	04-05-2013 10:37 AM
Should be a simple macro, need a start	Jamtart	PowerPoint	7	08-13-2012 06:11 AM
automatic start of macro + help on writing helper function	vsempoux	Word	3	10-09-2009 03:01 AM