Auto populate building block autotext on dependent drop down exit

gmaxey · #2 05-20-2020, 12:29 PM

The most casual search of this forum will indicate this question has been asked and answered before. In fact, a stating point would be the question asked by Mightymegs and answered by macropod just 7 posts below yours!

I'm not sure if Paul (macropod) addresses the building block in that thread (you should check) but when you know what was selected in the dropdown, you can insert some "named" building block in some "named" range using something like this:

Code:

Sub InsertBBatRange(BBName As String)
Dim oTmp As Template
Dim oRng As Range
  Set oTmp = NormalTemplate
  Set oRng = ActiveDocument.SelectContentControlsByTitle("Conditional Text").Item(1).Range
  oTmp.BuildingBlockEntries(BBName).Insert oRng, True
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto populate multiple text boxes dependent on a drop down	angelaschultz	Word VBA	7	03-18-2017 03:00 PM
Auto Populate Text On Dependent Drop Down Exit	GregStewartPTC	Word VBA	2	02-27-2017 05:37 AM
How to populate dependent dropdowns and auto-fill text fields simultaneously?	vera	Word VBA	1	10-07-2016 07:41 PM
VBA Word - Building Block (AutoText) - Array - Replace Text with Specific Building Blocks	jc491	Word VBA	7	01-03-2016 10:34 PM
Building blocks show correctly in dropdown, but wrong building block populates in doc	wordgirl123	Word	0	10-03-2013 08:30 AM