#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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?
|
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
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? |
#6
|
||||
|
||||
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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#7
|
|||
|
|||
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? |
#8
|
||||
|
||||
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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#9
|
|||
|
|||
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? |
#10
|
||||
|
||||
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 |
#11
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change color according with dropdown selection | spk | Word VBA | 43 | 07-31-2022 03:51 PM |
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 |
Dropdown selection value | coconutt | Word VBA | 5 | 09-13-2012 05:23 PM |