Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2017, 09:34 AM
jcothron jcothron is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2013
Novice
Multiple selection in a table word 2013
 
Join Date: Nov 2017
Posts: 5
jcothron is on a distinguished road
Default Multiple selection in a table word 2013


Please see attached Word document. We use this Word document for a Project Cover sheet on all of our jobs. As you can see from the table shown on the bottom of the document, we have notes pertaining to the job that are requirements for each job. We have several work stations in our shop designated on the document as MAT'L, QA, F10, F21, etc. I want to know the best way to list all of our work stations and notes so users are able to pick them as pulldowns and only the ones required are shown, multiple entries required, whenever they are requirements on the job. I am a novice, at best with Word. We are using Word 2013 and after reading online, a lot of people say to create a Userform. I do not have a clue how to do that and need to make sure that a Userform is easily edited, saveable and can print them with all information showing, I mean that the categories show when printing. I would like to keep this as a Word document, because that is what all our users are used to. The sample attached only includes just a smidgen of the notes and work stations we have to use. I have done the basics in the Header with the date picker, Engineer's initials, but I tried to place an Active X list box in the WS# column in the table in the bottom, changed the property to allow extended multiple, but I don't have a clue how to do anything else. Please help!
Attached Files
File Type: docx PROJECT_COVER_SHEET.docx (35.2 KB, 18 views)
Reply With Quote
  #2  
Old 11-29-2017, 05:06 AM
macropod's Avatar
macropod macropod is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your requirements appear fairly simple, though it's not clear what you mean by 'notes', 'only the ones required are shown' or 'multiple entries required'. You could use either dropdown content controls or dropdown formfields. For what you've specified, there is no need for a userform. How complex the document becomes depends on your clarification of the identified issues.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-29-2017, 05:42 AM
jcothron jcothron is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2013
Novice
Multiple selection in a table word 2013
 
Join Date: Nov 2017
Posts: 5
jcothron is on a distinguished road
Default Word document

Thank you Macropod for your speedy response. I am so sorry for not explaining what I want clearly. As I said before, I am a novice, at best with Word. Please let me try to explain what I need. We are a Manufacturing plant. We, the Engineers, design the assembly drawings necessary for our shop workers to build each piece. This document is used by the shop workers as a check off list of requirements on the jobs. That is why the WS#, Work Station, column is necessary.

We have a lot of repeating requirements, but we do have job specific requirements as well. In the column where we type the notes, "ACTUAL CMTRS WITH TRACEABILITY", I have figured out to use a Content Control box for those. This is easy because we only need (1) entry here.
My problem is in the WS#, Work station, column. This designates work stations in our shop. There are multiple work station associated with requirements. I do not know what to use to make this column a multiple list column. That being said I want to be able to show all available work stations in our shop but only pick the ones or one that are pertaining to requirement. Only that one shown in the WS# column. After reading about what to do on a Google search, I found to use a Active X list box to be able to show multiple selections. I tried to insert a list box and did it successfully but now I am stuck. Please help or let me know if I am still not clear what I want.

Windows 7 Professional 64bit
Microsoft Office Word 2013

I have attached the Word document that I was talking about, where I inserted the list box, after I do this, I don't know how to enter in my list of selections.
Attached Files
File Type: docx PROJECT COVER SHEET.docx (24.9 KB, 9 views)
Reply With Quote
  #4  
Old 11-29-2017, 02:14 PM
macropod's Avatar
macropod macropod is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

With content control dropdowns/comboboxes you can only select one item per dropdown/combobox. For an ActiveX listbox to work, you'd need to have a macro populate that listbox when the document is created/opened and, if you make selections, store those so the macro can re-select them next time the document is opened. That, in turn, means either storing the code that does the work in the document's template (meaning the document will only work on PCs that can access the template over your network or, if you use stand-alone PCs, the document will only work on PCs that the template has been installed on) or you'll have to save the document in the docm format - which is really only suitable if you're re-using the same document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-30-2017, 05:48 AM
jcothron jcothron is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2013
Novice
Multiple selection in a table word 2013
 
Join Date: Nov 2017
Posts: 5
jcothron is on a distinguished road
Default

Like I said before, I am a novice Word user. Macros will be out of my league. Thank you for your response and suggestions. I hope you have a very good day. Take care.
Reply With Quote
  #6  
Old 11-30-2017, 06:20 AM
macropod's Avatar
macropod macropod is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Macros being out of your league isn't the main issue - with which we can provide help. The main issue is how you're going to implement the process for multiple users.

An alternative, non-macro, approach you might consider is having a series of independent dropdowns for the Work station column, so users can choose a number of Work stations that way.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 11-30-2017, 07:26 AM
jcothron jcothron is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2013
Novice
Multiple selection in a table word 2013
 
Join Date: Nov 2017
Posts: 5
jcothron is on a distinguished road
Default

I have put multiple combo boxes into the Work station column, and that is a perfect suggestion, by the way. My only issue now is how do I make the row height in my table stay constant with all the multiple boxes taking up real estate. I unchecked the the Automatic resize to fit content option in my table, but the row still shows up sized to allow for the multiple combo boxes.
Please see example document.
Attached Files
File Type: docx PROJECT COVER SHEET.docx (24.5 KB, 15 views)
Reply With Quote
  #8  
Old 11-30-2017, 01:34 PM
macropod's Avatar
macropod macropod is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by jcothron View Post
My only issue now is how do I make the row height in my table stay constant with all the multiple boxes taking up real estate. I unchecked the the Automatic resize to fit content option in my table, but the row still shows up sized to allow for the multiple combo boxes.
That's a necessary consequence of having multiple dropdowns; without them being displayed, you couldn't see what selection had been made.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 12-01-2017, 12:28 PM
jcothron jcothron is offline Multiple selection in a table word 2013 Windows 7 64bit Multiple selection in a table word 2013 Office 2013
Novice
Multiple selection in a table word 2013
 
Join Date: Nov 2017
Posts: 5
jcothron is on a distinguished road
Default

Thank you so much for all your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple selection in a table word 2013 Excel 2013 Pulling data from 1 table to multiple sheets Justcallmeeesa Excel 2 04-14-2016 09:15 AM
Multiple selection in a table word 2013 How to number table cells continuously from a fixed point within the table in Word 2013 wondermuse Word Tables 15 12-07-2015 12:16 AM
Multiple selection in a table word 2013 Multiple Table of Contents MS Word 2013 dtb419 Word 1 07-20-2015 08:06 AM
Selection (range) in Word or Excel table NobodysPerfect Word VBA 2 09-16-2014 12:06 AM
Multiple selection in a table word 2013 Selection of all Text for a specific page in word is spanning selection across pages ramsgarla Word VBA 9 12-05-2012 03:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 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