Create Multiple Level Dependent Drop-Down Lists in Word - Fillable Forms with 3 Cascading Levels

Create Multiple Level Dependent Drop-Down Lists in Word - Fillable Forms with 3 Cascading Levels

Sharon Smith

4 года назад

81,846 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@pancux670
@pancux670 - 20.09.2023 20:26

Thanks for your very helpful videos. I want drop down list in MS word from a table created already in MS Word or Excel List. How can I accomplish this? Please help

Ответить
@hafizqamarfarooq3060
@hafizqamarfarooq3060 - 18.08.2023 21:27

Hi! @SharonSmith, Thanks for Helping! I have a Question
Can We create dependent Text fields and Image upload field next to 2nd dependent dropdown. if please send me the code. I'm stuck on it.

Ответить
@agengelsantos2503
@agengelsantos2503 - 13.03.2023 05:29

Hi Sharon, how about adding a form field that automatically displays the ZIP CODE??
I am extremly grateful to you for making this channel, your way of explaining and smiling is the best. Thank you very much🤩

Ответить
@albanieves7073
@albanieves7073 - 03.02.2023 03:00

How many options can be listed for each dropdown, is there a limit?

Ответить
@lb7048
@lb7048 - 18.01.2023 19:38

Is there a way to do a single dd box that populates two drop downs? For example 2 drop downs dependent on one box.

Ответить
@divadreamer713
@divadreamer713 - 12.01.2023 05:19

Hi Sharon, I have the dependent drop down working. I need to modify the code to add in more options, how do I find the visual basic script and make the changes?

Ответить
@MVPSuccess
@MVPSuccess - 22.12.2022 23:01

Just spent two days on this and now it's telling me I have a 25 list limitation. Looked around the web, no workarounds... ideas?

Ответить
@meditatewithme9
@meditatewithme9 - 21.11.2022 21:50

Thank you for the amazing demo, I have a requirement where I need to update a label based on my dropdown selection. Can you please help me what changes I should make in the code to add any value depending on my dropdown selection

Ответить
@andaonu1391
@andaonu1391 - 21.10.2022 21:12

Thank you Sharon for sharing this. I have two questions though: 1. Does this method work for Office 365? and 2. How do you get rid of the "5825" Error - as this kept on appearing, in my case as well, each time I was changing the option in my first dropdown form? Best, Anda

Ответить
@aminmousavi2027
@aminmousavi2027 - 20.10.2022 22:49

Thanks for this video. This drop-down list does not work for Farsi language.
persian font is not displayed correctly. Is there a way to solve this issue?

Ответить
@MDDapp
@MDDapp - 20.09.2022 23:14

Hello Sharon,
Great video. Is it possible to create these dependent drop downs without the visual basic?
My company restricts the use of macros.

Ответить
@uramir31
@uramir31 - 30.08.2022 15:15

Many thanks for this dropdown. But I am using a template with field (instead of Fill Form) in that it is not working. Could you please help?

Ответить
@nitxanit5133
@nitxanit5133 - 22.07.2022 20:19

Please, how can I buy this template?

Ответить
@marioperdomor.5685
@marioperdomor.5685 - 13.07.2022 02:02

Hi Sharon, thanks for this. I am trying to do a contract form/cover letter for several cases, I would like to have a dropdown menu for the title, eg. "Lease" and then have the several references in the document be made to "tenant" and "landlord" just by choosing "Lease", and if I select a different contract title, e.g. "Sale" have these same reference change to "Seller" and "Buyer" within the document, how can I do this? Conversely, I could also use something like having the contract title dropdown command/define all of the text for the rest contract where such references to the parties would be made accordingly. Could you please explain how to do this?

Ответить
@angelinamontecino8672
@angelinamontecino8672 - 08.07.2022 07:32

What if I don’t have the “bookmark” in the properties section of the drop down to create the bookmark name. It’s a new version on word it think than yours in the video.

Ответить
@charlottelee5076
@charlottelee5076 - 04.07.2022 19:05

Thank you for this, it is just what I have been looking for. I would like to expand this to allow two dependent drop down from the initial selection e.g. name in 1st list can select from drop down 2 and 3 but a different name can only chose from drop down 2 and has no option for drop down 3, is this possible?

Ответить
@dawnseymour6238
@dawnseymour6238 - 22.06.2022 21:03

Thanks for this video and all your others! Do you happen to have a video that shows how to do the multi-level dependent dropdown lists using content controls? Or does it work exactly the same way?

Ответить
@user-epslesvou
@user-epslesvou - 22.06.2022 17:49

can you make o video how to make dependent drop down list using data from excel? in example i want to creat a document in which when i select the person i want to send it will fill automatically some data from excel for this person.

Ответить
@marjafuga
@marjafuga - 22.06.2022 03:52

How to Create a Combo Box Containing More Than 25 Items

Ответить
@marjafuga
@marjafuga - 22.06.2022 02:44

Me encantan sus videos, solo que tengo un inconvenientes, deseo colocar mas de 25 item en el segundo cuadro de menú desplegable, pero no me lo permite. Me marca un error de depuración. Existe alguna forma de aumentar los item del segundo combo desplegable. Muy agradecido por sus enseñanzas, están increibles sus videos

Ответить
@clarachen9205
@clarachen9205 - 17.06.2022 18:13

Hi Sharon, thank you for your video, that’s really helpful!I have a question here: if I need to have a superscript in the drop down menu, do you know how to make that happen? The Word won’t allow me to do that. Thanks!

Ответить
@Timbrr100
@Timbrr100 - 22.05.2022 19:15

Great instruction. I do have a question about saving multiple forms to specific folders. If I do client notes for multiple encounters, can I save each encounter note in a chronological fashion to a specific folder, and how. Perhaps you can refer me to a video that covers this subject. Thank you for your very helpful instruction.
Tim Hughes

Ответить
@nunyabusiness6769
@nunyabusiness6769 - 01.04.2022 07:31

Hi Sharon, you are amazing. I have a question though...how does one text wrap a drop down form field? I do hope you can answer this. :/

Ответить
@lindaandriko4537
@lindaandriko4537 - 16.03.2022 14:40

Hi Sharon! Thank you so much for these very useful videos They have been a life saver for my current project. I am trying to learn how to populate a drop down based on two cases. For instance: case "1st shift" + case "1 year of experience" .add "$17.25" Is this even possible?

Ответить
@soccervideos7183
@soccervideos7183 - 10.03.2022 01:43

Thanks Sharon for this video. I was able to use your example/template and make edits to my forms. When I showed the updates to my Customers they were so happy.

Ответить
@pancux670
@pancux670 - 28.02.2022 20:19

Thanks for such awesome content.

Ответить
@davidhogan2395
@davidhogan2395 - 22.02.2022 01:03

Hi Sharon, for the 3rd and final field output box. Can that be replicated in multiple locations? As in I want it to populate DD1 but also have the same population for DD2, DD3 and DD4 that are separate DD's in different areas of the form? hope that makes sense.

Ответить
@pXxDisasteRxXq
@pXxDisasteRxXq - 14.02.2022 00:33

hello,
just a basic question: how can I get the text written in a legacy plain text control via VBA?

Thanks!

Ответить
@rogermccollough5310
@rogermccollough5310 - 08.02.2022 15:28

Is there a way to do this using the newer Content control drop down list instead of the legacy forms?

Ответить
@anthonycoachman9206
@anthonycoachman9206 - 12.01.2022 17:53

Thanks Sharon! I love your videos, you make them so easy to understand and explain it in a way that I didn't get in the MOS class that I took.

Ответить
@stephaniepates3081
@stephaniepates3081 - 07.01.2022 23:29

Can I have colored text in my drop down? If so how?

Ответить
@mariahpaez1753
@mariahpaez1753 - 17.12.2021 06:08

Great video. I have a question regarding repetition. Say you were using the form in your video but you wanted 5 columns for all the same information. Is this possible? For example, you have column 1 that has Region, State and City drop downs. Columns 2, 3, 4, and 5 all would need the exact same information and drops downs. Is this possible? Thanks again. Your videos are so helpful!

Ответить
@Parroteer
@Parroteer - 13.11.2021 09:45

i wonder is there a way instead of users selecting the 2nd box and 3rd box themselves, it'll auto filled it for them when they select the first box.
I've been digging this around the world.. I don't seems to find this anywhere.

Ответить
@Silver.Forest
@Silver.Forest - 21.10.2021 13:44

The presentations you give are easily understood. I'm learning so quickly. Thank you!

Ответить
@vanessawaiters6756
@vanessawaiters6756 - 18.10.2021 06:59

Sharon,
Loved the post. Can’t quite get the calculations to work at each level. Trying to create a form with two levels, i.e., each one with corresponding formulas.

Ответить
@LucasWestfall
@LucasWestfall - 23.09.2021 00:48

So I've followed the steps and used the provided code as a baseline but I'm having script errors when running it. Is there something flagrantly wrong with this script?

Sub PopulateSubtype2()
Select Case ActiveDocument.FormFields(“Species1”).Result
Case "Core - Faeyr"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dylithar"
.Add "Miaki"
.Add "Tiermalain"
End With
Case "Core - Human"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Akkadian"
.Add "Krimmerian"
.Add "Ennocean"
.Add "Innelain"
.Add "Midian"
.Add "Sutherland"
.Add "Xiao"
End With
Case "Core - Romling"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add “Traditional”
End With
Case "Core - Svar"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dargnan"
.Add "Mordron"
.Add "Kargathi"
End With
Case "Dimi"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Faeyr"
.Add "Romling"
.Add "Spawn: Devourer"
.Add "Spawn: Imbued"
.Add "Svar"
End With
Case "Kith - Chimerian"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Beautiful"
.Add "Fast"
.Add "Powerful"
.Add "Resilient"
End With
Case "Kith - Daemonkin"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Ash’dren"
.Add "Fel’dren"
.Add "Goblyn"
.Add "Lillian"
End With
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dryad"
.Add "Nereid"
.Add "Oread"
.Add "Salamander"
.Add "Sylphkin"
End With
End Select
End Sub

Ответить
@soniagill2285
@soniagill2285 - 02.09.2021 15:01

Hi Sharon! Thank you for your amazing videos! I just have one question, on my dependent drop down, my sentence is too long for one line, am I able to word wrap a Legacy Control, in this case a drop down control? Your help is greatly appreciated!

Ответить
@haalkab6297
@haalkab6297 - 30.08.2021 22:02

Sharon, thank you so much for this video, it was an opening! However, the list is limited to 25 items, is there a way to have unlimited items on the list?

Ответить
@alisontait8718
@alisontait8718 - 11.08.2021 13:28

Hi Sharon, great videos! so clear and informative. I have managed to create a dependent dropdown within a larger form I am working on. I have saved this as a .dotm file, all works great for me but when my colleague tested it, she does not get the drop down options. Is there a security step that I have missed? do I need to be able to share the macro?? hope you can help as the form will be great when we get the access fixed. Many thanks

Ответить
@sandipbhogal6280
@sandipbhogal6280 - 05.08.2021 20:02

can you show us how you got NewMacros tab on your vb? we're pretty much lost here its just we're not able to get the script to work so you dont something that we didn't catch on your video

Ответить
@gionik5019
@gionik5019 - 21.07.2021 20:13

Hi again Sharon =).

Now I have a difficult challenge for you =). Are you ready?

Do you know if you can create a form where you have two dependent drop down boxes and a free text box below. When you have filled in all the information in the sections above, completely new lines are autogenerated with two dependent drop down boxes and a free text box below, if you want to create a form for several different cases to be handled. Your video is amazing.

Ответить
@ronnysavels2410
@ronnysavels2410 - 21.07.2021 19:06

Hi Sharon.
Maby you can help me.
I have a word template to save documents, send them with a macro using outlook library.
I want to create a field in my template like the email to field in outlook.

Ответить
@gionik5019
@gionik5019 - 30.06.2021 20:04

Thaaaaaank you. Amazing

Ответить
@sandipbhogal6280
@sandipbhogal6280 - 27.06.2021 11:40

How can i add multiple entries in a drop down list?

Ответить
@sandipbhogal6280
@sandipbhogal6280 - 27.06.2021 11:40

How can i add multiple entries in a drop down list?

Ответить
@heidyhernandez7726
@heidyhernandez7726 - 17.06.2021 01:13

I have tried this and it doest seem to work for me I have no idea what im doing wrong.

Ответить
@AnuragKumar-hv1df
@AnuragKumar-hv1df - 29.05.2021 17:54

Nice Explanation

Ответить
@kellyames5269
@kellyames5269 - 04.05.2021 17:14

Hi Sharon - Is there a way to have three sets of the same multi dependent drop-downs? I've tried copying and pasting as well as creating four additional modules, but the VBC breaks when l I start populating the second set of multi depending drop downs. Thank you.

Ответить
@reduanabdulmajid9054
@reduanabdulmajid9054 - 24.03.2021 07:53

Hi, please help me, i made the form using your example, i use on my computer, it was fine. When i transfer the word doc to my friend pc, it does not operate correctly. Do i have to copy the macro script to the new pc?

Ответить