Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2020, 06:11 AM
pgg1507 pgg1507 is offline How to generate a clauses document from 10 yes/no selections with some Sub-selections Windows 10 How to generate a clauses document from 10 yes/no selections with some Sub-selections Office 2010
Novice
How to generate a clauses document from 10 yes/no selections with some Sub-selections
 
Join Date: Oct 2020
Posts: 2
pgg1507 is on a distinguished road
Default How to generate a clauses document from 10 yes/no selections with some Sub-selections

Hello,
Am not sure if MS Word would be the best to create such a document. Could it be Excel?

Am just looking for guidance.

What I'm trying to do is from a form with 10 Yes/No questions, (some questions include multiple choice check-boxes), is to insert clauses in the reply to the client selections.



There's a possibility that conditions exists, for example question 5 & 6 have to be answered to generate the clause. Meaning combination of Yes/Yes, Yes/No, No/No, No/Yes.

I am not a programmer but I can get the needed support as required.
thank you
Reply With Quote
  #2  
Old 10-13-2020, 08:18 AM
Charles Kenyon Charles Kenyon is offline How to generate a clauses document from 10 yes/no selections with some Sub-selections Windows 10 How to generate a clauses document from 10 yes/no selections with some Sub-selections Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,928
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

Generally, Word is better at documents than Excel, and Excel is better at calculations than Word.

Look into creating a UserForm (custom dialog box). This requires writing (not recording) macros.

Your clauses could be stored in the template as AutoText. That is easier, at least for me, than putting the wording into the macro.
Reply With Quote
  #3  
Old 10-18-2020, 03:59 AM
pgg1507 pgg1507 is offline How to generate a clauses document from 10 yes/no selections with some Sub-selections Windows 10 How to generate a clauses document from 10 yes/no selections with some Sub-selections Office 2010
Novice
How to generate a clauses document from 10 yes/no selections with some Sub-selections
 
Join Date: Oct 2020
Posts: 2
pgg1507 is on a distinguished road
Default Thank you

Thank you for pointing me in the right direction. Have quite some research ahead of me.
Reply With Quote
Reply

Tags
auto generate clauses, yes/no dropbox

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capture menu selections in VBA trevorc Excel Programming 0 11-19-2018 06:55 PM
How to generate a clauses document from 10 yes/no selections with some Sub-selections Creating a letter in Word, with text pulled from an Excel document based on selections in a userform TMAL Word VBA 6 12-15-2017 02:16 PM
Generating text from table selections valdavaux Word 3 10-11-2017 08:46 AM
How to generate a clauses document from 10 yes/no selections with some Sub-selections Help with Hide/Display of sections of document based on Drop Down selections turnquistcm Word 2 05-03-2017 07:05 PM
How to generate a clauses document from 10 yes/no selections with some Sub-selections Trying to generate a result from selections Gatorchamp Word 1 03-29-2017 02:31 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:36 AM.


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