Microsoft Office Forums - View Single Post - A yes or no OptionButton in Userform inserts a building block

Thread: A yes or no OptionButton in Userform inserts a building block

View Single Post

Old

06-14-2015, 11:19 PM

gmayor

gmayor is offline

gmayor uses Windows 7 64bit

Windows 7 64bit gmayor uses Office 2010 32bit

gmayor uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,142

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

You don't actually need the range name on this occasion, though I tend to use them through force of habit.

Code:

ActiveDocument.AttachedTemplate.BuildingBlockEntries("AddtValSiteBB").Insert _
                Where:=ActiveDocument.Bookmarks("AddtValSites").Range

would have done the job.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote