Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-30-2015, 09:13 PM
360Inspect 360Inspect is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2015
Posts: 2
360Inspect is on a distinguished road
Exclamation Looking for Assistance to Perfect my Inspection Report Functionality - Auto Inserting Text, etc.

Hello,



I am looking for assistance on perfecting some reports that I use on a daily basis in Word. I am a Home Inspector and I have templates laid out in Word for my inspection reports in which I enter information about a property and insert comments about deficiencies that I find.

My main question at this point is - Is there a way to use a Combo Box Content Control to insert a specified line of formatted text into a specified section of my report? Also to the extent of having each item in the combo box insert a different line of text in various areas of the report?

I know it may sound complicated, but I'm sure some bright minds can help me figure it out. Please feel free to ask for any other information you might need to help out. Thanks in advance!
Reply With Quote
  #2  
Old 01-31-2015, 12:29 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,448
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

The short answer to your question is yes, but the more elegant solution is to create a userform in the template to drive the document creation. You can have a combo box (or whatever) to insert whatever you want into the document at whatever location according to what is entered/selected. For the basics see http://www.gmayor.com/Userform.htm. The end result can be as simple or as complex as you want to make it.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 02-01-2015, 07:16 AM
360Inspect 360Inspect is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2015
Posts: 2
360Inspect is on a distinguished road
Default

Thanks for the reply,

I've been researching the options of having my CC drop down insert items from my Building Blocks Gallery...Would someone be willing to help with the coding involved in this?

For example I have a drop down that specifies the temperature on the day of the inspection. If the temperature is below 18*C then we cannot test the A/C since it can cause damage to the equipment so I have a disclosure from my building blocks gallery stating this that I manually insert into a specific section of my report.

This type of issue occurs in many places within my report.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
Text Box with Word Functionality? elmousa68 Word VBA 3 01-09-2014 01:55 AM
Automatically inserting information into report joughin Word 3 05-15-2012 09:12 PM
Inspection Form report in word 2010. aligahk06 Word 0 07-12-2010 05:42 AM
"Inserting" 11x17 blank sheet into report mcjohn Word 2 01-06-2010 09:14 AM


All times are GMT -7. The time now is 06:30 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft