View Single Post
 
Old 06-12-2015, 08:03 PM
HighSierra HighSierra is offline Windows XP Office 2010 64bit
Novice
 
Join Date: May 2015
Posts: 7
HighSierra is on a distinguished road
Default A yes or no OptionButton in Userform inserts a building block

Hi All,

I've spent hours trying to figure this out.... I feel really certain this is possible.

I have a question in a Userform with OptionButton 13 and 12 corresponding to Yes or No. If the user selects Yes, I want a buildingblock that I already created in the template called AddtValSiteBB to insert after a bookmark already existing in the template. If no, I want nothing to happen.

I have this so far:

Private Sub CommandButton1_Click()

Dim AddtValSiteBB As BuildingBlock
If OptionButton13 = True Then AddtValSiteBB =
If OptionButton13 = False Then AddtValSiteBB = " "

End If


With ActiveDocument
.Bookmarks("AddtValSites").Range _
.InsertAfter AddtValSiteBB
End With

End Sub


I tried all sorts of ways to define the AssValSiteBB as the building block in the active document...to no avail...

Any help would be AMAZING.

Thanks!
Reply With Quote