Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2019, 07:06 AM
gmaxey gmaxey is offline Using a UserForm to fill blanks in a letter Windows 10 Using a UserForm to fill blanks in a letter Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

As for the checkbox (included specific paragraphs). That depends on the strategy you use. One is to just include everything in the template and then delete the pieces you don't want:




Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
Dim bCheckTarget1 As Boolean 'Simulates a checkbox value
Dim oRng As Range
  bCheckTarget1 = False
  If Not bCheckTarget1 Then
    Set oRng = ActiveDocument.SelectContentControlsByTitle("Target1").Item(1).Range
    ActiveDocument.SelectContentControlsByTitle("Target1").Item(1).Delete True
    oRng.Paragraphs(1).Range.Delete
  End If
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply

Tags
template drop-down, userform, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a UserForm to fill blanks in a letter Form Filling, setting up a standard letter to pop up with prompts to fill in certain areas Joanne Bombardier Word 2 10-07-2018 05:49 PM
Using a UserForm to fill blanks in a letter How to draw a fill in the blanks ? kingston123 Word 2 09-21-2018 05:49 AM
Using a UserForm to fill blanks in a letter Help, Fill in the blank type form letter Bumbledor Word 4 02-06-2015 10:17 AM
Using a UserForm to fill blanks in a letter fill blanks in box keevitaja Word 1 05-23-2011 06:34 PM
using word/able to fill blanks w/o moving rest Rath Word 3 03-07-2009 08:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft