Create Dependent Drop-Down List in Word - Fillable Forms Microsoft Word

Рет қаралды 170,167

Күн бұрын

HOW TO CREATE A DEPENDENT DROP-DOWN LIST IN MS WORD 365 - LEGACY TOOL DROP DOWN FORM FIELD WITH VISUAL BASIC CODE // Watch this video to create a drop-down fillable form field in Word that limits the choices for users to select from, depending on how they answered a previous question. Make your form simpler for users and minimize errors in users selecting the wrong options by implementing this dependent drop-down list in your fillable form as applicable.
**YOU WILL NEED TO SAVE YOUR DOCUMENT AS A "WORD MACRO-ENABLED DOCUMENT (.docm)"
No prior knowledge of Visual Basic code is needed. Simply watch this video and use the code, highlighted in the video, that is pasted below. Be sure to follow all the steps and instructions in the video so you'll know how to modify this code to fit your particular needs. Here is the Visual Basic code used in the module in this video. Remember to replace "ddStatus", "ddSurvey" and anything in quotes with your own form field bookmark labels and drop-down list options respectively.
Sub PopulateddStatus()
Dim xDirection As FormField
Dim xState As FormField
On Error Resume Next
Set xDirection = ActiveDocument.FormFields("ddStatus")
Set xState = ActiveDocument.FormFields("ddSurvey")
If ((xDirection Is Nothing) Or (xState Is Nothing)) Then Exit Sub
With xState.DropDown.ListEntries
.Clear
Select Case xDirection.Result
Case "Active"
.Add "Completed"
.Add "In Progress"
.Add "Not Started"
Case "Inactive"
.Add "Do Not Engage Employee is Inactive"
End Select
End With
End Sub
_________
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 1: • How To Create A Fillab...
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 2: • Make Fillable Forms in...
TIP: To ensure the Developer tab is visible in MS Word so you can insert form fields, follow these steps:
1) Right Click on the Ribbon area and select "Customize Ribbon"
2) The Customize Ribbon and Keyboard Shortcuts window opens
3) On the right hand side under "Customize the Ribbon - Main Tab" ensure the "Developer" checkbox is selected, then click OK.
__________
FREE DOWNLOADS:
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
RESOURCES:
✦ JotForm: www.jotform.com/pricing/?utm_...
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #MSWord, microsoft word tutorial, create fillable forms, dependent drop down list in word, fillable forms in word, microsoft word legacy tools, microsoft word legacy tools form fields, enable developer tab, visual basic in word, visual basic code for dependent drop-down list, visual basic module example, word productivity tools, word macro enabled document, dependent drop-down form field, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: • How To Create A Fillab...
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

Пікірлер: 365

@musicmusicalmusic 2 жыл бұрын

This was by far the best instructional video on this topic. I watched so many other videos trying to understand how to use the dropdown menu

@SharonSmith 2 жыл бұрын

That is awesome to hear! So glad you found my video helpful. I try to be helpful and to the point. Thanks for watching!

@geshauminskiy7781 Жыл бұрын

Thank you! Video is straight to the point with fantastic visuals, great editing. Wish all tutorials were this productive.

@SharonSmith Жыл бұрын

Thank you so much for the nice feedback, Gesha! I'm glad you find my videos helpful. Thanks for watching!

@virgilmanolache8448 3 жыл бұрын

Hi Sharin, tons of thanks for these videos, you're a lifesaver. I do need your help further though and I am sure more of us do... We would need the code / tutorial to see how we can hide or show a field based on user choices from a dropdown list. I'm struggling bad at it.... thanks!!

@SharonSmith 4 жыл бұрын

This video was inspired by one of my viewer's questions after watching my other videos on creating fillable forms. Thanks for the great questions and be sure to leave comments or share tips below. You can access my other fillable form videos Part 1 (kzfaq.info/get/bejne/j9GkjZZzktrdoac.html) and Part 2 (kzfaq.info/get/bejne/pMV-nMKXz5OVZWw.html) from my channel. A huge Thanks to all my subscribers! Thank you for watching!

@anakjantans4 4 жыл бұрын

Amazing

@danielr4398 4 жыл бұрын

This is great. Thank you. I have another problem in the same vein as this and I can't figure out how to do it. Do you know how to get text from a text-form-field to appear as a selection in a drop-down field box? For example, I have a form where the user has to fill in the names of their employees in text box fields. I then ask the manager to select the "best" or "hardest working" individual in their store. The goal is to have the names (as they were typed in the field) to appear in a drop-down box. I know it has to be a macro, but I don't know how. This has been driving me crazy for years. This has so may uses for so many different fields. Please help.

@debbieburnette1582 Жыл бұрын

This was amazing! I've been spending a day on LinkedIn Learning trying to figure out how to do this exact thing and you taught me in minutes. Thank you!

@SharonSmith 11 ай бұрын

That is great to hear! I'm so glad you found my videos helpful. Thanks for watching and for subscribing to my Channel!

@spartyonhaji 2 жыл бұрын

thanks for the video...it's exactly what I was looking for and you even made the Visual Basic part painless!

@SharonSmith 2 жыл бұрын

Glad you found it helpful, Benjamin! Thanks for watching!

@p-cide4857 3 жыл бұрын

You are just too good Sharon. Thanks for the resource. You now have a new subscriber. I normally build this kind of form in Adobe Acrobat and Livecycle, now trying to explore MS Word.

@SharonSmith 3 жыл бұрын

Hi P-cide! Thanks so much for subscribing to my channel and watching my videos. I'm so glad you find them helpful. Yes, as long as your users can open your form in MS Word, it is a great option to create fillable forms. I appreciate you taking time to leave a comment! Take care!

@renyirish 3 жыл бұрын

This is incredibly helpful!!! Thanks a lot for your straight forward explanation!

@SharonSmith 3 жыл бұрын

Glad to help! Thanks for watching!!

@drjulie7460 2 жыл бұрын

Hi Sharon! A coworker recently introduced me to your channel and it is AMAZING!! Your tutorial videos are so well done, easy to follow and a game changer! I am working on a form with dependent drop downs, I was able to successfully follow your tutorial and make the basics work. I have two questions. I have a long list of categories (parent), some of which have sub-categories (child). However there are some categories that do not have a sub-category, so I want the sub-category box to not have any selection available for those categories and be greyed out with no ability to click on it. How would I code that? My second question is, this list of categories and sub-categories is quite long. Do I just make one long set of code for the module? Or would it be better/preferred to make a different module for each category/sub-category pair? Thanks again, your channel is awesome!!

@marieferrante4962 2 жыл бұрын

Hi Sharon! This video was SO helpful, I'm really loving your channel!! Quick question, if I'm making a table that has 12 rows and each row needs to contain a dependent drop-down list, how can I copy and paste to each row so that I don't have to go through the VBA 12 times. Thank you!!!

@nathandobratz7071 4 жыл бұрын

Great video. Extremely well thought out and user friendly.

@SharonSmith 4 жыл бұрын

Thank you so much Nathan! Glad you found my videos helpful. Thanks so much for watching and taking time to leave a nice comment. Take care!

@othomiley4120 2 жыл бұрын

Thank you Sharon, This helped me a lot. My script was much longer than this one but the basis was perfect.

@SharonSmith 2 жыл бұрын

Glad to help! Thanks for watching!!

@moondriftstar7482 2 жыл бұрын

Hi Sharon, thanks for the vid. Apologies if I'm reapeating a question (I couldn't find the answer below). Is there a way of naming the child list prior to making a selection in it? The reason I ask, is that I am using the dropdowns to write reports, so I have removed the "form field shading" - which then means the child list is not visible until you put a cursor on it. That's fine if it is just me using it, but it's a bit more difficult if I give it to other to use.

@mandyreno9564 3 жыл бұрын

This was SOOO helpful!!! Thank you so much for sharing this in an easy to understand and straightforward video. You saved me sooo much time trying to code.

@SharonSmith 3 жыл бұрын

Hi Mandy, thank you! I'm so glad you found it helpful. I have another video on multiple level dependent drop-downs in case you are interested: kzfaq.info/get/bejne/a5qUhq2m0MjJY58.html Thanks for watching and taking time to leave a nice comment, I appreciate it!

@denverdanny3381 2 жыл бұрын

i guess im asking randomly but does anyone know a trick to get back into an instagram account?? I stupidly forgot my login password. I would love any help you can give me

@landennixon9532 2 жыл бұрын

@Denver Danny Instablaster ;)

@denverdanny3381 2 жыл бұрын

@Landen Nixon I really appreciate your reply. I found the site through google and I'm in the hacking process atm. Looks like it's gonna take a while so I will get back to you later with my results.

@denverdanny3381 2 жыл бұрын

@Landen Nixon it worked and I now got access to my account again. I'm so happy! Thanks so much you really help me out :D

@ecllalle 2 жыл бұрын

Thank you for the tutorial and the VBA. However, i made this for a form in work today and I have to select the required option in the first drop down at least TWICE for it to load properly in the second drop down. I have quite a few options in each drop down. is it due to this? Is this quite limited on how many options to have? Or is there anything else i can look for?

@maverick19_ 2 жыл бұрын

Thanks for the awesome content Sharon, appreciated. Please advise how can I create a multiple dropdown list. For e.g I want to have multiple employee names on the dropdown list without going in each time to seperately create/add them. Am I able to perhaps export the employee list into the dropdown list? Thanks,

@sarahbonello1826 4 жыл бұрын

Great thanks! I would like to have larger bodies of text as a drop down option, is this possible in word? Depending on the doc they are creating depends on the legislation wording they need, I want to give people the option to select the legislation from the drop down so it inserts in their doc. Any ideas much appreciated.

@XLnCADMalayalam 4 жыл бұрын

Thanks for this Information. Didn't know that Dependent Drop Down Menus are possible in Word.

@SharonSmith 4 жыл бұрын

Glad you found this video helpful! Thanks so much for watching and taking time to leave a comment. Take care!

@dickbratcher1250 3 жыл бұрын

Hi Sharon, this video was very helpful. I'm trying to create a dependent drop down list in a repeating section in Word 2016. This isn't working, which I assume is because there are then multiple instances of the parent and child drop down list. Is there a way to get the functionality I want, which is to be able to add rows to a table that allow selection of different parent and child list items in each row?

@basmabayoumi2732 3 жыл бұрын

Thank you for such a video. If there were categories to certain services and each service has few points as details, how would I create a sub-DD list under the service category's list?

@daveflores7250 2 жыл бұрын

Sharon, this was of great help and is much appreciated. But I have a issue where my child fields are coming up bold, how do I prevent this from happening?

@Fuzzie_bear 3 жыл бұрын

Thank-you Sharen, This video was very helpful!

@SharonSmith 3 жыл бұрын

You are very welcome, Mike! Thanks so much for watching!

@omniscient420 2 жыл бұрын

This video was super helpful but I'm having an issue. Once the code is edited and saved, when I restrict the document and test it, it functions fine on my workstation. Once I send the document, the second drop down option doesn't populate correctly, if at all. Sometimes, the dependant drop down populates as if another parent selection was chosen when it was not. I've made sure that the formatting of the Visual basic code is consistent, and everything aligns as it should. Any suggestions?

@c0urtzz1 2 жыл бұрын

Thankyou so much, this is so helpful!!! Is there a way to include colouring as well in this code? In my word doc I have a table format, and I am trying to find a way to colourfill the boxes in depending on the first selection (so for this example if Active was selected how could I autofill the box green, and if Inactive was selected how could I tell it to autofill the box red)?

@cassandramaygerman6793 2 жыл бұрын

Hello! New subscriber here. I don't have any VBA background and found this very useful! Quick question, if i were to make dependent combo boxes in Outlook custom forms, how would the code look like? Many thanks! 🙏❤️

@chrisnaidoo4596 2 жыл бұрын

Thanks for these great videos! One question: 1 - Can I create a drop down list where the user can select multiple options using check box selection for the Parent field/s and dependent on which field/s are checked, then a corresponding section of required fields needs to be displayed and so on....? Example is Section A, Section B, etc.

@alialbayati9368 4 жыл бұрын

Very informative and easy to do, thank you so much.

@SharonSmith 4 жыл бұрын

Thank you very much Ali! I'm so glad you found this video helpful. I have some more videos coming out soon that I'm working on that are related to other viewer's questions on creating fillable forms. Thanks so much for watching and taking time to leave comments! Take care!

@paulburns6110 2 жыл бұрын

This is awesome thanks. As a mere stale pale male, who's fond of excel, I found it far too clunky for ease of use. The word option is a lot more streamlined. It's a game changer.

@SharonSmith 2 жыл бұрын

Glad you found my videos helpful, Paul! Thanks so much for watching!

@CinemaInsight 2 жыл бұрын

Hello Sharon, I just need to know How to create a dropdown menu for the particulars column and auto-fill in the Unit Rate column. Thank You!

@saberab3257 2 жыл бұрын

Hi. Is there a way that different editable text can appear, in response to an option that is selected? Hope that makes sense! Thanks

@kelbeardsall2068 3 жыл бұрын

i need to create a form that links responses from question 1 to required items for example if you say in question one you are a fulltime employee a window or response box needs to open with text that describes what you need to provide as proof of this.. can this apply to that or this another method, as there are multiple fields that will need to be added to this enquiry form

@Mae_chan 3 жыл бұрын

How to do a combo box that add word in it and can add values this is my project for ITAAPS subject and im struggeling...

@ella7650 2 жыл бұрын

Hi Sharon, Thanks for this video. Is it possible to have a bullet list in the child section? .Add " - A - B - C"

@RobinsonsWorld2020 4 жыл бұрын

Very informative video. First time watching dependant drop-down list and vb coding for word.!!

@SharonSmith 4 жыл бұрын

Thank you so much! I'm glad you liked it. You have a great channel and I like your new channel art. Thanks for watching!

@RobinsonsWorld2020 4 жыл бұрын

Sharon Smith Thank you for your comment. Sorry, you won’t understand my language, it is Malayalam. If you like, please subscribe my channel. I have few videos in English too !

@nitinule 3 жыл бұрын

Loved the Tutorial and the way you explain. Subscribing. Best wishes from Mumbai

@SharonSmith 3 жыл бұрын

Thank you so much for subscribing and watching my videos! I'm glad you like them and find them helpful. Best wishes to you too! Thank you!

@candicebeverly6527 2 жыл бұрын

This is amazing! Is there a way to have one parent and 10-15 children? The children only are dependent on the first parent question.

@surianisuhaimi3782 8 ай бұрын

HI, i am so happy i actually did it and thanks to you. It's been so helpful. Hers's the thing, i wanna ask, if the line statement is too long and it went off paper margin, how can i make the line in two rows.

@roopeshtube 2 жыл бұрын

Thanks for video. I have a requirement of disabling the dropdowns based on the value selected value in the parent dropdown. I have say three values in the first down and accordingly three another drop down lists with associated values in each drop down list. If I select the first value in the parent drown ( say the value is A), then only the drown named A should be selectable and remaining drop downs ( Say B&C) should not be selectable.

@ofergoren2301 2 жыл бұрын

GREAT!!! Professional and helpful! Thank you! Could you tell me how to create a numbered list in a "Free text" field -- every time the user hits Enter

@Elemalele 3 жыл бұрын

What about multiple-select options in the drop down menu? Is that possible? If so, then how? Thank you.

@852Henshin 3 жыл бұрын

Dear Sharon, Q1) I am confused in the 3 types of control: Content control, Legacy control & ActiveX Control. Q2) Under which condition should I use which control ?

@TheCoupleholicCanada 2 жыл бұрын

Hello Sharon thank you for such an informative videos. If you can make a video on how to auto-populate information to another page by selecting drop-down options in MS word which is VBA enabled. For example table with drop-down is on first page and have macros, how we can have the same information copied over to the 4th page of the same word file. Looking forward for the same. Thanks

@IrishMcCheez 2 жыл бұрын

Your videos are very clear & understandable and I love the content! I have a question - maybe you could help? How do I add a dependent text box based on a drop-down list? For example, if they choose 'Other - Please explain.' I want the input text box to normally hide unless the 'Other' option is selected. I've spent 3 days trying to find the answer through Google & KZfaq and don't understand why I haven't found an answer. Maybe I'm phrasing the question wrong. By the way, your thumbnails are the best! (The ones for your videos, not the ones on your actual thumbs.)

@amandametz4888 Жыл бұрын

Does anyone have an answer for this?

@paulinewan7538 3 жыл бұрын

Is there a way to use an excel list for the drop down field options? My context - i have a database of items with specific names/serial numbers (>100 items) and i need to populate selected item from this only database into a document

@abhishekgautam8879 2 жыл бұрын

Great video, thanks, Can you do a video to demonstrate how we can have an expandable/collapsible Heading and its content on the checked and unchecked status of a Checkbox. It would be greatly appreciated. Thanks in advance.

@alicjajakubowska9544 3 жыл бұрын

Your films are very helpful! Thanks to You I became fan of MS Word. You make a graet job! Could You tell me if there is a possibility to fill drop-down list with subscript? I want to make a list with stuff like K_z etc

@meyanyusuf312 2 жыл бұрын

Thank you, how do I add code if the option is others and the user needs to type the option

@nicoleh546 3 жыл бұрын

Thank you so much for the informative video!! I had to play around because there were differences on Mac Word. For anyone else looking for Mac instructions: Adding Developer tab: Word (left of File) Preferences Authoring and Proofing Tools Ribbon & Toolbar Main Tabs Developer In Developer: Combo Box (in Ribbon) Options (in Ribbon) Visual Basic (in Ribbon) Insert Module Paste the code (edit) Protect Form (in Ribbon)

@SharonSmith 3 жыл бұрын

Thanks for sharing the info for Word for Mac! Thanks for watching!

@rogersaunders5825 2 жыл бұрын

@@SharonSmith Hi Sharon, thanks for the excellent video. I have a set of business names and associated addresses that I used your code to allow users to select the business name and the associated address would be displayed. I used a Windows machine to develop the solution and the result works perfectly on that laptop. On the MacBook Pro however, it does not. Only one address is shown (constantly). Is this a compatibility issue do you think?

@imkurteh 3 жыл бұрын

Can this be done with the ActiveX/Content-Control style dropdowns?

@LoveGOdess7 3 жыл бұрын

Thank you so much this was really helpful.

@SharonSmith 3 жыл бұрын

You are very welcome Zeljka! Glad you found it helpful. I also have another video that shows how to set up multiple levels of dependent drop downs: kzfaq.info/get/bejne/a5qUhq2m0MjJY58.html Thanks so much for watching!

@olibriusc3133 Жыл бұрын

Hi, I am trying to create a drop down menu with previously filled value in text form as drop down options. How could I do that ? Thank you very much for your time. (for exemple I would have a fillable that would be "name of person 1" and a second would be "name of person 2" and in the drop down menu I would have the choice between both name that were entered.)

@zoeygarcia3112 3 жыл бұрын

Dear Sharon I created a dependent drop-down list but one of the selection is not working

@georgiealderdice1923 3 жыл бұрын

Thank you so much for sharing this Sharon, it really helped! I would like to ask how i make a drop down list that isn't dependable and is just to choose one of the items out of the list (for example just selecting the bank we will do a loan through)

@SharonSmith 3 жыл бұрын

Hi Georgie! You can simply insert a legacy tool drop-down form field and open properties by double-clicking and then just list the drop-down answer options you want and "add" them. You don't need to use any VBA code or anything to create this. Here are some more videos in my Creating Fillable Forms playlist that will show you how to do this. I hope it helps! Thanks so much for watching! kzfaq.info/sun/PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

@mahmudmirza3451 2 жыл бұрын

If I have say about 5 set of 2 dropdown boxes in the same document and I need all 5 to be doing the same dependent selection then how can I avoid having 5 subroutines with the same functionality? I mean is there a way to check which set of dropdown boxes (out of of 5) is in-use so that only those 2 are updated? I know in VB6 you can call a subroutine with index so is there something similar?

@joseescott4954 Жыл бұрын

This is an amazing video. I have a question...how to I add in Visual basic the blank field and it not being dependent? Hope this makes sense.

@maryanndetrizio4372 Жыл бұрын

Is there a way to create a multiple drop down list in word that is nondependent? I need a user to select all applicable options in my drop down list. Thank you. Your channel is super helpful.

@SueChenTranslationpluss 2 жыл бұрын

Very helpful tips. Thank you very much!!!!!!

@SharonSmith 2 жыл бұрын

You are very welcome! Thanks for watching!

@dereckdowler5491 10 ай бұрын

This video was a great help. Is there a way to import the dependent drop down values from an excel sheet as opposed to typing them into an Add method? Thank you in advance.

@Kortney357Warren 3 жыл бұрын

What if I was doing a survey and if any "Yes" answers means client should not be seen. How would I do this?

@Cendrinne 3 жыл бұрын

Hello, how can we create a dropdown list of our own ribbon labels? I have so many macros that I've added on my own ribbons, however, some could be put as a dropdown list to take less room. I can't seem to find a video on that.

@JuanFernandoPazCaicedo Жыл бұрын

hi there, thanks for explaining. Its is possible To create a dependent list from a dependent list. I mean I need to create a credit line that has a code and each code has some products it

@kamoyfarrington3139 4 жыл бұрын

This video was a huge blessing, thanks for posting! I have an issue and hoping you can help me. I'm creating an interview guide, where a manager can select a competency and then select one of the loaded questions specific to that competency (dependent drop-down). Some of my interview questions are long and when selected, they continue on the same line and I cannot see the end of the sentence. How do I force the sentence to go to the next line?

@SharonSmith 4 жыл бұрын

Hi Kamoy! Thank you so much for your nice comments and I'm so glad you found my videos helpful. I did some research to try and solve your issue, however I have not found that it is possible in Word to have text wrap from within the drop-down selection. From what I have read, there are not many easy solutions out there that offer the ability to have paragraph-like drop-down answers (longer than one line) in Word, but it also seems to be an issue in other solutions as well. One thing you might consider if you know Excel very well, you may be able to create your form in Excel. You can design the format of the spreadsheet by merging cells and using borders and you can hide tabs that might contain your data. I'm working on tutorials on Excel forms in the near future and perhaps this can help you. I wish you luck with your form! Thanks again for watching and taking time to leave a comment!!

@tutuh9816 3 жыл бұрын

this was great. I need a dropdown list for a user to select which state they are from. Is there a way to do this without having to type in all 50 states?

@motodude45 2 жыл бұрын

Is there a way to get these drop down list to automatically update when you select the status drop down, the survey drop down list automatically populates? The way it is here, you have to manually select both lists.

@bhutanesedamsel 3 жыл бұрын

Is there a limitation to how many cases you can add? I added 7 cases and the last two of them doesn’t show up. Please help!

@A_Box Жыл бұрын

Hello Sharon. I have aquestion: Is it possible to insert paragraphs as items for the combobox? What I want to do is have a drop down menu that lets me choose from 2 or more paragraphs.

@michaelb9129 2 жыл бұрын

Is it possible to create a list of numbers in a specific range in a dropdown box (in the non-legacy controls). For example, if I wanted to create a dropdown list for a user to select a quantity ranging from 1-1000, is it possible to quickly and easily generate that list of options without manually inputting all 1000 different numbers into the list?

@blacksteedeyes 10 ай бұрын

Hi, if I have a certain form it have an original information and I would like to ask other to add on certain parts without allowing him to do changes to the original document how we can do that?

@amenaesmail9455 3 жыл бұрын

Hi Sharon, Great Video, really helpful! I was wondering, can you do a dependent drop down with the combo box option rather than the legacy tool drop down option? I want to have a title for the text that would be chosen however the 'display name/value' in the modify option does not work how I thought it would have.

@bobglover3119 2 жыл бұрын

Hi, did you ever get a reply for this question, i know exactly what your looking to do.

@belindaschouten3060 3 жыл бұрын

An what if I want the depending drop down only to show one option and that option has to show directly fter chosing dropdown 1. For example you chose Active then €200,- and if you chose inactive then €300,- is that possible. I have tried a drop down but that I have to update the field and I have tried a form field but then the field does not sumup anymore, because at the end some amounts have to sum up, with a drop down that works but as a field with a code in it not. thanks a lot nice videos!

@tarahwilliams7325 Жыл бұрын

Hi Sharon, it looks like i'm a little late to the party, but i have a very specific question. I'm creating a (hopefully) dependent form. 1. Do you have to use all legacy controls throughout the entire form in order to make any portion dependent? I have date pickers throughout the form, but i noticed the date picker is not part of the legacy control family. 2. I need to be able to make dependents on a drop down. The end user will select the number of sessions they will need from the drop down (1-5). If they select 1 session, the form will populate the information they need to fill out for one session (a table). If they select that they need 5 sessions in the drop-down, it will need to open up all 5 tables to fill out information for each session, if that makes sense. The way i have it now, all 5 tables are open and it makes the document 8 pages. I don't want it to be 8 pages if it doesn't need to be. I have a mix of controls throughout the document.

@missnae703 4 жыл бұрын

Great video!!! Instant Sub!

@SharonSmith 4 жыл бұрын

Thanks so much!! Glad you found my videos helpful and thanks for leaving a comment and subscribing! Take care!

@nancyv.7254 Жыл бұрын

Your videos are great! Very detailed and well explained. Thank you. I do have a question, what if there's only a portion of the document that is a drop down form, the remaining sections are free text field and can be modified? By Restricting Editing, no other changes to the entire document is possible. Is there a way to only restrict editing on the drop down?

@ThatSavvySpecialEducator Жыл бұрын

I'm wondering this as well!!! I usually use Google docs which makes it super easy to insert dropdown menus within a table. Microsoft Word seems behind the times in this area. I am using a MacBook Pro, and the developer ribbon options look different.

@gilbernstein5862 9 ай бұрын

Very helpful video! Any idea if I can use a similar approach to perform auto text fill thorough the word doc based on a drop list chosen value ?

@SharonSmith 9 ай бұрын

Here are two videos you may find helpful. This video is how to set up fields that will auto-repeat throughout your document: kzfaq.info/get/bejne/lbGPe7Z5taycY4U.html and here is a video on how to make text or images appear based on a drop-down selection: kzfaq.info/get/bejne/i6t4mLem25vYd2Q.html Thanks for watching!

@stagweekenders2528 2 жыл бұрын

I have a question. I want to create an application form with a dropdown menu that includes different countries. When UK is selected, it will show a different set of questions to fill in, another different set for Germany, US etc. is this achievable?

@iuhoosierssoccer3011 2 жыл бұрын

I have a document that not only needs dependent drop down fields, but also for the user to edit other fields and even write in information. Is there a way to activate the dependent drop down fields without having to protect the document so that the only editing the viewer can conduct are in the fill-in fields? I need the viewer to be able to edit the entire document.

@iriselbers4705 3 жыл бұрын

Hi, I love the clear ways you explain everything. Question: if there is just one option, is there a way to have this automatically pop up instead of having to click and select the one option?

@SharonSmith 3 жыл бұрын

Hi Iris! Are you referring to having text appear based on filling in a form field? If so, I have a video on this topic: kzfaq.info/get/bejne/jLWAicSJt9C3k30.html I also have a video on how to link text to appear based on a drop-down selection. If there is only one, you can set the the option to default as the first choice: kzfaq.info/get/bejne/i6t4mLem25vYd2Q.html. I hope this helps! Thanks for watching!

@belindaschouten3060 3 жыл бұрын

yes I want this too :-)

@dmarti47 2 жыл бұрын

Thanks for the video. I did exactly as you instructed but nothing happened in the second field. So, I believe you forgot to mention that one also has to double-click on the second field, go to Run macro on Entry and select the module.

@nayanzope4732 3 жыл бұрын

I want check box option in index while how many heading I will check in check box their respective page should be their document and the rest which are not select should disappear. Please tell me how to do that

@mluization 3 жыл бұрын

how can I create the navigation (go to) drop-down menu?

@SlightlyVertigo 2 жыл бұрын

Hi Sharon. Great video. I was curious if there is a way to "Restrict Editing" only in the drop down menus while still allowing other area of the document to be edited/filled in? I have a doc I want to provide Dependent Drop Down Menus to allow for quicker data entry, but still need some areas to allow for manual entry. For example: For SOP creation - Parent DD = Department & Child DD = Roles, but then allowing for manual entry of process in separate field.

@SharonSmith 2 жыл бұрын

Hi James! Here is a video that may help you on how to lock only part of your document: kzfaq.info/get/bejne/jtmYabecm96ucmw.html I hope this helps! Thanks for watching!

@lovelace0586 8 ай бұрын

Great, that was my want, thank you.

@SharonSmith 8 ай бұрын

Glad to help! thanks for watching!

@matthewparkes2336 2 жыл бұрын

How do u link a combobox out come to a text box if selected yes , text box appears to specify

@darwinmiller9660 2 жыл бұрын

i am trying to do a drop down list with 2 items. one item is taxed and the other is not. so if i click the drop down list and choose the one that is taxed , i am wanting the total tax amount to show up in a box. can you help?

@oliviaduong9493 2 жыл бұрын

Hi Sharon, I am attempting to link text/image to a dependent drop down. Is that possible? It doesn't seem to be working for me.

@MrHoyle88 Жыл бұрын

Can I make a dependent drop down using the content control drop down list? If not, how can I use the legacy drop down but NOT restrict the entire form. There are other areas on the form that the user will need to type in.

@eliweiss8859 4 жыл бұрын

Great and informative video Sharon. Thank you for sharing. I was wondering if you can help lay it out a little further for me. I am trying to create a Word form (a Fax cover sheet actually) where I would have a drop-down of several recipient names and I am trying to have their phone # and fax # auto-populate or auto-fill based on the name selection. Is that possible?

@SharonSmith 4 жыл бұрын

Hi Eli! I would recommend you create your fax cover sheet template in Excel instead of Word in order to easily auto-populate phone # and fax # based on a selected name from a drop-down field. You can merge cells as needed to format your page so that when printed, you wouldn't know it was an Excel spreadsheet. You would use Data Validation to create your name selection drop-down and then use VLOOKUP to populate cells for Phone and Fax based on the name the user selects. I will work on a video to show how to do this. It would be difficult to try and create this in Word. Thanks so much for watching my videos! Take care!

@maverick19_ 2 жыл бұрын

If one selects an option from a dropdown list, can it automatocally create another template? Like an employee list, I selected Tom so Tom must be in a new template & so on.

@rosanageronimo8180 4 жыл бұрын

thank you so much, how to create one of the drop-down lists, and I would like to have the options (display name) show but when one is selected have the dollar value (value) associated with the display name populate.

@SharonSmith 4 жыл бұрын

Hi Rosana! Can you let me know your form field examples (what display names and dollar values)) and I'll see if I can figure out how to help. Thanks for watching my videos!!

@hhampton Жыл бұрын

I have several Yes/No questions on the form I am working on where if the person answers "Yes" they need to give details. If they answer "No" they would go on to the next question without further comment. Is there a way to do this with dependent drop-down boxes? Or is there another, better way?

@sdvaughan5474 2 жыл бұрын

For some reason I keep having issues with second drop down. It does not show any option after selecting primary. What am I missing here?

@trisnoinnax3572 2 жыл бұрын

Good tutorial and thank you. Is it possible to change the grey color of the legacy drop-down form tool?

@SharonSmith 2 жыл бұрын

Hello - the Legacy tool form fields gray shading can be turned off, but there are no other options to change the color of the form field properties. You can actually select the form field and then use the "Highlight" feature on the Home tab - Font area but you have limited color options there. Here is a video on how to turn off the gray shading in case you want to do that: kzfaq.info/get/bejne/Y8eii7tqqrGuYJs.html Hope this helps! Thanks for watching!

@mbhazimangoveni3068 Жыл бұрын

Great work, I am a big fan.

@SharonSmith Жыл бұрын

Thank you, Mbhazima! Thanks for watching my channel!

@ashrafzulkarnain65 2 жыл бұрын

Hello Sharon, I have encountered a problem. For some reason, I cannot send the completed Word Document (with all the macros and coding) through email in Outlook. The file extension of .docm has been flagged as Malware in Outlook. May I know how can I send the word containing all the macros to my recipients? I would like them to fill out the forms. Thank you in advance.

@CinemaInsight 2 жыл бұрын

How do I create a Dropdown List and AutoFill value to another cell in Microsoft Word?, I need to create a dropdown list on the particulars column and required auto value in the rate column. (e.g: Product A = $100)

@medicalcoder9463 Жыл бұрын

Yes it is helpful! Thanks a lot!

@SharonSmith Жыл бұрын

Glad you found it helpful! Thanks for watching!

@sudarshangupta5635 2 жыл бұрын

can the background color of drop down be changed to white??

@gameerzzz4140 2 жыл бұрын

Hi ma'am. How can we Create table of different line and columns. And I appreciate how you explain everything very simple.

@rafa1126 2 жыл бұрын

Sharon, thankyou for your awesome video! I'm trying to do one more dependent, how do I add a third conditional drop-down linked at the second answer?

@SharonSmith 2 жыл бұрын

Hi Rafael! Here is a video that may help you do that for multiple level dependent drop-downs: kzfaq.info/get/bejne/a5qUhq2m0MjJY58.html Thanks for watching!

@CruxCollective 2 ай бұрын

HELLLLLP lol I cannot get mine to work, do I need to do something different when using tables? Like depending upon the DD selection I want one table with a set of questions to appear and another when the second option is selected?? 😭😭😭 I’m thinking the table is messing it up. Any thoughts?