Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2015, 03:50 AM
alfienoakes alfienoakes is offline Form assistance - complete noob, sorry Windows 7 64bit Form assistance - complete noob, sorry Office 2010 32bit
Novice
Form assistance - complete noob, sorry
 
Join Date: Mar 2015
Posts: 2
alfienoakes is on a distinguished road
Question Form assistance - complete noob, sorry

Hi all,

I have tried to find an answer to my query on this forum but without success, so apologies in advance.

I am trying to create a template that will be a report of standard findings. The report will have standard wording in ....ie: Joe Bloggs have not got x y and z in place. (3 separate findings), but I want the user to be able to input the name of the recipient (will it be an input box) and then it autofill the report with their name in the various sections, saving the user to have to type that out.



Also bearing in mind the circumstances, I want the user to be able to pick from the findings so that it populates. When finished the report can be saved and sent out.

How do I go about this please, I have no knowledge of VB, is it easy?

Many thanks in advance, I am grateful for any assistance.

Regards,

Alf.
Reply With Quote
  #2  
Old 03-16-2015, 05:17 AM
gmayor's Avatar
gmayor gmayor is offline Form assistance - complete noob, sorry Windows 7 64bit Form assistance - complete noob, sorry Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Starting from scratch without VBA knowledge you are going to have a very steep learning curve.

What is required for this task is a userform - http://www.gmayor.com/Userform.htm with list or combo boxes for the selectable items and text boxes for names etc. The input values from that userform are then transferred to the document via bookmarked locations or docvariable fields.

See also http://gregmaxey.com/Create_and_employ_a_UserForm.htm for a more in depth study.

If starting out in Word VBA, the place to begin is to gain an understanding of the use of ranges. See http://gregmaxey.com/word_tip_pages/vba_basics.html which explains the various concepts including ranges.
__________________
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
  #3  
Old 03-16-2015, 07:02 AM
alfienoakes alfienoakes is offline Form assistance - complete noob, sorry Windows 7 64bit Form assistance - complete noob, sorry Office 2010 32bit
Novice
Form assistance - complete noob, sorry
 
Join Date: Mar 2015
Posts: 2
alfienoakes is on a distinguished road
Default

Thank you Graham, I will try.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Complete dansim Word 0 09-16-2014 08:37 AM
Form assistance - complete noob, sorry physical complete %, regular work, vs % complete ketanco Project 1 06-16-2014 11:08 AM
Form assistance - complete noob, sorry Noob question Fantasytrader Word VBA 1 03-14-2012 06:30 PM
Noob questions punktilend Word 0 07-24-2009 02:41 AM
A Noob Question Techknology Outlook 0 11-30-2006 07:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:27 PM.


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