Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2018, 04:11 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default Report Containing Multi-Selection Dropdown


Is it possible to create a standard report that contains multiple selection dropdowns at certain parts in the report? I already have a report with dropdowns but can only select one option. Can I change my existing report to enable multi selection or would I need to start again?
Reply With Quote
  #2  
Old 06-12-2018, 05:54 AM
gmayor's Avatar
gmayor gmayor is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2016
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

The short answer is no. You could however use a list box on a userform and insert multiple selections from the list box into a content control (or controls), in whatever format you require.
__________________
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 06-12-2018, 06:16 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default

Thank you for confirming this for me. I have tried to set up a userform with a list box but didn't succeed. I don't have any knowledge about it, therefore I don't understand a lot of it. Do you know if there is anywhere I could obtain easy guidance from the beginning with this?
Reply With Quote
  #4  
Old 06-12-2018, 11:02 PM
gmayor's Avatar
gmayor gmayor is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2016
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

https://www.gmayor.com/Userform.htm should get you started.
__________________
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
  #5  
Old 06-14-2018, 06:20 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default

Thank you Graham, the link was very useful and I managed to follow everything but I am now thinking that maybe this isn't what I need for example I have a report that is issued in paragraphs and throughout the paragraph at present I have drop boxes with various options to select e.g. Satisfactory/Unsatisfactory/Upon completion/Not suitable/After remedial work. Only one of these can be selected and inserted into the paragraph but I would like to be able to select more than one.

Do you think that userform and listbox are the best way to go about this?
Reply With Quote
  #6  
Old 06-15-2018, 04:31 AM
gmayor's Avatar
gmayor gmayor is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2016
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

None of the dropdown box options available to be inserted into a document support multiple selection. The only way to do this is with a userform listbox.



You can put text content controls at the positions required with an on-entry macro that calls the userform. At its simplest this can be seen in the example attached. Click in either control.
Attached Files
File Type: docm Example.docm (37.5 KB, 25 views)
__________________
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
  #7  
Old 06-15-2018, 06:33 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default

Oh my god, that is exactly what I'm looking for, you are amazing, thank you.

Now if I wanted to use the same kind of thing throughout the document but with different selections, would I need to create different userboxes and macros for each one or should I just add all the selectable items to this one?
Reply With Quote
  #8  
Old 06-15-2018, 06:54 AM
gmayor's Avatar
gmayor gmayor is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2016
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

You can use the same userform for the same task throughout, you just have to tell the macro which control to process and which list to use for that control - I have identified them, by tag (see attached update).


You should find https://www.gmayor.com/insert_content_control_addin.htm useful.
Attached Files
File Type: docm Example.docm (41.0 KB, 17 views)
__________________
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
  #9  
Old 06-15-2018, 08:36 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default

Absolutely brilliant. I have spent a lot of time trying to work it all out. It must be great to have the knowledge to do this.

Just an afterthought .... is it easy enough to enter a blank option for the user to insert various text?
Reply With Quote
  #10  
Old 06-15-2018, 07:47 PM
gmayor's Avatar
gmayor gmayor is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2016
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

As the userform writes to a content control you could cancel the macro and write what you want in the content control.
__________________
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
  #11  
Old 06-20-2018, 08:58 AM
Donnatoye Donnatoye is offline Report Containing Multi-Selection Dropdown Windows 10 Report Containing Multi-Selection Dropdown Office 2013
Novice
Report Containing Multi-Selection Dropdown
 
Join Date: Jun 2018
Posts: 6
Donnatoye is on a distinguished road
Default

I think I will avoid that one then.

Do you know if a new line can be entered at the end of each selection instead of it all running as one paragraph if the selections are long?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Containing Multi-Selection Dropdown Change color according with dropdown selection spk Word VBA 43 07-31-2022 03:51 PM
Report Containing Multi-Selection Dropdown Multiple Selection Dropdown list ajanson Word VBA 36 07-15-2019 08:16 PM
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
block selection in dropdown list Intruder Excel 2 01-10-2013 10:20 AM
Report Containing Multi-Selection Dropdown Dropdown selection value coconutt Word VBA 5 09-13-2012 05:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


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