How To Link Text or Images To A Drop-Down List Selection in MS Word - Create Fillable Forms

HOW TO LINK TEXT OR IMAGES TO A DROP-DOWN LIST SELECTION IN MS WORD - CREATE FILLABLE FORMS // Learn make text or an image appear in your document based off what a user selects from a drop-down list. This video will show you how to do this using a Time-Off Request Form where different instructions and time off reasons appear if a user selects the employment status of Full-Time vs. Part-time. This technique can be used to also insert a particular image file depending on the drop-down item selected. We review this using signature image files at the end of this form.
You can purchase my form template at: www.etsy.com/listing/88162091... in case you want to use the field code as an example or customize this template to fit your needs. This video will show you how to set up a form with similar functionality. Thank you for supporting my channel!
Want to take your form-building skills to the next level? Consider taking my Course on Creating Fillable Forms in Microsoft Word:
• Creating Fillable Form...
__________
RESOURCES & GEAR
✦ Screen Recording Software: techsmith.z6rjha.net/NZG5b
✦ Green Screen: amzn.to/2DnHsY2
✦ Camera: amzn.to/39KvpQA
✦ JotForm: www.jotform.com/pricing/?utm_...
✦ PresenterMedia: 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!
__________
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!
__________
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
__________
KEYWORDS: #MSWord, #M365, How To Link Text or Images To A Drop-Down List Selection in MS Word, How To Make Text Automatically Appear After User Selects From A Drop-Down List, Conditional Question Formatting in MS Word, How To Create Conditional Formatting in Word Forms, Create Fillable Forms in Word, Program Conditional Formatting in Word Forms, Insert Photo in a Drop-Down, MS Word Tutorial, MS Word Lesson, Creating Fillable Forms, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ 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

[@SharonSmith]

Want to take your form-building skills to the next level? 🚀 Checkout my KZbin Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," kzbin.info/aero/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs where your frequently asked questions on forms are answered, like how to insert a Submit form button that works with any email client and how to export completed form data to Excel quickly and easily. 💡 The Course includes 15 video lessons, a handy PDF workbook with all lesson summaries and VB code tidbits, and two versions of the Word form template we build together (a behavior-based interview questionnaire form). You can still always access all the free content on my Channel (over 100+ video tutorials). Please note that the KZbin Courses feature is in Beta and currently limited to a subset of Creators. Courses are only available in the United States, South Korea, and India. Viewers must use a computer or Android device to buy a Course. We hope KZbin Courses will roll out to more Creators, devices, and regions in the future! Thank you for taking the time to checkout my Course! You may see some of your other favorite KZbin Creators who have also launched Courses by going to their Channel page and clicking on the "Playlist" tab. Enjoy!

[@hrk.videos]

Kindly, show how to add a watermark to the entire page easily. As I see that predefined templates provide only one word.

[@drthanhtam]

Thanks for for teaching Sharon. Your kindness changes the world.

[@SharonSmith]

You are very welcome, and thank you for your kind words! Thanks for watching my videos!

[@wingame52]

after using MS Word for years, never had I imagined it could do so much. Or that users can insert codes into Word. The explanations were clear and easy to follow. thank you!

[@SharonSmith]

So glad you found it helpful and easy to follow. Best of luck to you! Thanks for watching!

[@angelahoward3001]

Hi sharon. I am leaping with joy. I tried out the part for adding image signature and it worked. I'm so so excited. I really want to thank you for your video and how your tutorial is so straight forward and simple. Thumbs up and keep up the great work.

[@SharonSmith]

Thanks so much Angela!! That is great feedback and I'm so glad this worked for you. Thanks for watching!

[@mgcservices7524]

THANK YOU, Sharon! This has certainly helped with adding large amounts of text depending on the answer to the question. You're a star - Have a great New Year.

[@SharonSmith]

You are very welcome Malcolm! Glad to help! Have a Happy New Year!

[@simonmccormack605]

Sharon, thank you so much for the forms videos. They are amazing!!!

[@SharonSmith]

Thank you Simon! So glad you found my videos helpful! Thanks for watching!

[@michaelwilcox1913]

Thank you so much Sharon. I didn't realise that this was what i was looking for until I found it. Very helpful and extremely easy to follow.

[@SharonSmith]

That is great to hear, Michael! Glad you found my videos! Thanks for watching!

[@chilosopher]

Saved me 3 hours googling online.... Thank you!!!!!!

[@SharonSmith]

You are welcome! Glad you found this video and that it saved you some time!! Thanks for watching!

[@6tromboner9]

Thank you so much! I stumbled upon this tutorial, but it's one of the things I was wondering about. Definitely a well-done video. It also showed me that I want to be using the Legacy Tools instead of the newer standard ones.

[@SharonSmith]

Hi Mike! So glad you found my videos helpful. Yes, you can do a lot with the legacy tool form fields. I have a playlist on my channel related to creating fillable forms you may find helpful: kzbin.info/aero/PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv Thanks so much for watching!

[@trentzajac4335]

We provide scripts to our managers during separations conversations. What we say depends on certain aspects of the separations. This will be a perfect way to create an automated script that varies depends on the circumstances of the separation! So thankful this popped up in my recommended!

[@SharonSmith]

That is great Trent! I'm so glad you found this helpful so you can automate your scripts. That sounds like a great tool/resource for your managers to assist them with those difficult conversations. Best of luck! Thanks for watching and for subscribing to my Channel!

[@ukeitaa]

This is such a thorough and detailed tutorial, thank you!

[@SharonSmith]

So glad to hear you found it helpful! Thanks for watching!

[@migoram]

hello Sharon i am french and you have no idea how happy i am o have found your channel.I learn a lot and love your voice thank you so much .I don't even understand how you don't have more follower

[@SharonSmith]

Thank you Michelle! I am so happy you found my channel and I'm very glad to hear you find my videos helpful and that you are learning a lot. Yes, I hope to grow my channel with more followers! Thank you for watching!

[@JoshCamson]

Terrific video. I had a different use case and used the IF functionality coupled with an ASK function for making letterhead that pre-populates different signatures. Worked like a charm.

[@SharonSmith]

That is awesome, Josh! So glad you found this helpful and that you were able to build on it to create what you needed. Thanks for watching my videos! Best of luck!

[@mariaglezildasoriano7259]

This is amazing! Thank you so much for sharing this!!!

[@SharonSmith]

Thanks Meg! So glad you found my videos helpful. Thanks for watching and taking time to leave a comment!!

[@lawrencereid]

Nice, clear and calm instructions. I actually enjoy listening to your instructions.....Can apply this today when I create a form for my boss. She wants some new automation when documenting work instructions

[@SharonSmith]

Hi Lawrence! I'm so glad you like my videos and glad to hear you can use this to help you at work! That is my goal. Good luck and thanks for watching my videos!

[@terryguire1321]

I'll definitely be looking to your channel to develop practical Power User skills. This was a great lesson!

[@SharonSmith]

Thank you so much, Terry, for the Super Thanks!! I really appreciate your support! I'm so glad you find my videos helpful. Thanks for subscribing to my Channel. Best of luck to you!

[@sebastianschick1989]

Sharon, thanks a lot for this very helpful tutorial. Is there a limitation as it regards the number of options (if-clauses) and the amount of characters? In my case I have up to six options and at least some of them do have more the 256 characters.

[@shardagovender4465]

Thank you, I am a new subscriber and finding the content extremely useful.

[@SharonSmith]

Hello Sharda! Thank you so much for subscribing to my channel and watching my videos. I'm glad to hear you find them helpful! Take care!

[@rogangranite]

Thank you so much another great video.

[@SharonSmith]

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

[@anniel6458]

Hi Sharon, thank you for this video! It was very helpful. I wanted to expand on this premise by not just having a couple sentences of text appear once a drop-down list option is selected, but an entire set of steps. However, when I enforce protection and then select the applicable option from the drop-down then "tab", it moves me to the end of the steps. Is there a way to stop this from happening (i.e. remain on step 2) instead of moving to the last step? Or can you recommend another solution for displaying multiple sets of steps based on the drop-down list selection? Thanks again!

[@burgessinspectionsinc1847]

Great video! Thank you for this. Is there a syntax that can be used when the drop down uses two words? I seem to get this to work only when the dropdown is a single word, or connected words.

[@VijayendranRaghavendran]

Thank you very much for the video. Very useful.

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@luismauricio1277]

Thank You it was very helpful.

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@hermannvalsson4237]

Great way to teach thank you.

[@SharonSmith]

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

[@sidflashgaminggghacker9223]

You are awesome Sharon

[@SharonSmith]

Thanks so much, Abubakr! Thanks for watching my videos!

[@shareitwithit7323]

Thank you Sharon it very professional explanation

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@arjavkumar]

Hi Sharon, nice tutorial. I have a question: What if we don't select the 'calculate on exit' checkmark at 10:16?

[@yours.trustworthy]

Omg this is extremely good Thanks

[@SharonSmith]

Thank you so much!! Thanks for watching my videos. Glad you find them helpful. Take care!

[@sandrabrennan7411]

Hi Sharon great videos thank you. I am new to this and have created a document following your instructions and it worked great. My question is how am I able to view and edit the different linked text if I have to do so.

[@abdelouahabelboukhari1078]

Hi Sharon. Thank you for your videos! is it possible to force the user to check only one Check Box among multiple ones? Like for example, if the user must rate something based on a Likert scale from 1 to 5.

[@Kshais]

Nice, thank you!

[@SharonSmith]

You are very welcome! Thanks for watching!

[@megathaziq2019]

Thank you very much for teaching Sharon. Greatly appreciated it. I just one question, can we do this in header and footer because I want to link image when select drop down list in header.

[@christopherwilson4103]

This Video and all your others are fantastic - I've learned loads... thank you so much! Do you know how I could adapt the statement fro display set according to a check-box rather than a drop-down? I've tried to adapt the IF statement but I haven't had much success.

[@SharonSmith]

Hi Christopher! Glad to hear you have learned a lot. I am researching this now, several people have this same question. Thanks so much for watching my videos!

[@ry-tf1mx]

THANK YOU !

[@SharonSmith]

You are very welcome! Thanks for watching!

[@georgiostheodorou9946]

Very useful and very unique material

[@SharonSmith]

Thank you Georgios! Glad you found this helpful. Thanks so much for watching and taking time to leave a comment!

[@cindyklier103]

Hi Sharon, I have been watching your video's and have learned a great deal from you. Thank you for producing these. I was wondering if you could provide a tutorial on using a drop down that would produce multiple options within an editable text field that is mostly prefilled with text, but includes additional drop downs, form fields and date pickers. Thank you :)

[@tanguerochas]

Cindy, for that you may want to be using Content Controls instead of legacy form fields together with AutoText/Building Blocks. Use the Building Blocks Gallery Content Control.

[@alielsheikh8091]

Very useful and a lot of new info, tips and tricks here.. Keep it up

[@SharonSmith]

Thank you so much Ali! So glad you found my videos helpful! Thank you for watching!

[@akulomnarayan6663]

Mam ur One of the best presentational videos.

[@SharonSmith]

Thank you so much, that is so nice of you. Thanks for watching my videos!

[@tansarayut3533]

I love this tutorial

[@SharonSmith]

Thanks so much for watching! Glad you found it helpful!

[@westonmckain2690]

Thank you, Sharon. This video helped immensely. Is it also possible to include a plain text form field within the condition? So, the drop-down selection would essentially create another item for the user to fill out. It haven't had any luck doing this.

[@canada_boneyfamily9283]

Thank you for these tutorials. I do have an inquiry, how to i use a dependent form to add a table(s) based on the selection.

[@suresighthomeinspectioninc6540]

This is the first of all the "how-to" videos out there that addresses this, thanks! I didn't know this was possible. Quick question. Is there a way to add text like in this tutorial if a legacy checkbox is selected? I tried using the same code you used for the drop-down list but it doesn't work. You would forever be my hero if you could let us know how to do this with a check box.

[@SharonSmith]

This is a great question and several people have asked about this. I'm researching it now. Thanks so much for watching my videos!

[@juliemalmstrom2869]

Awesome videos! It appears there is an issue when drop down options start with the same number or word. Do the drop downs have to be completely different from each other for the correct text to populate?

[@anwarmunna3241]

Thank you so much.....

[@SharonSmith]

Thanks for watching!

[@mehedihasan-kf4uy]

thank you so much

[@SharonSmith]

Glad you liked it! Thanks for watching!

[@mahmoodmajeed6967]

Hi Sharon, thanks for the excellent video! A question pop up in my mind - under "Reason for Request" is it possible that only the checkboxes which contain text against them appear and none of the checkboxes is without text? Would be a great help if you could provide a solution to that. Thank you once again, you are awesome!

[@Riodejenny]

Thank you! This was exactly what I needed! Now, once I test the document my coding goes away. How do I get it to show back up in case there is an error and I need to fix it? Again, fantastic videos!

[@steffanmarx1918]

hi sharon, once you have made the formula work, can you use them without having to turn on limited editing? my document jumps around when I use the dropdown fields... GREAT VIDEO :D

[@CarlaGrangerOlivares]

hello! excellent video thank you very much, it helped me a lot at work; and I was wondering if it is possible that from the selection of an element in the document the header changes. I tried to follow the same instructions, but it tells me that there is an error because the second part of the condition is missing. I would really appreciate it if you help me, thanks in advance. love your channel

[@_tati.tati.tati_]

You enlighten me 😇😇😇

[@_tati.tati.tati_]

After watching this I'd been following the same (typing the same, following each step-by-step, for several times. THOUGH, it didn't work for me. The auto-words didn't show up and moreover, I could not fix the font style. Can you recommend on how I can fix this?

[@Survdim]

🙌You the best

[@SharonSmith]

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

[@joshuabees]

Sharon thank you so much for this! One question - Is there a way to be able to ctrl-C the output text created using this method? I'm using it to automatically build a document from just a few selections but the users need to be able to copy & paste out the results. Thank you again for your tutorials, I never knew Word could do so much!

[@tonyhekopiano5892]

Brilliant.

[@SharonSmith]

Thank you, Tony! Thanks for watching!

[@tonyhekopiano5892]

@@SharonSmith in our company we use Microsoft Word heavily for various test procedures and what you are showing here shows that things can be done differently to make it faster and standardized.

[@lindseyhotz2327]

Love this video - very helpful! Can this be done referring to whether a checkbox is marked or not? For instance, if someone checks "vacation", can we create an IF statement that shows certain additional text regarding using vacation time?

[@SharonSmith]

Hi Lindsey, unfortunately the same technique does not seem to work with checkboxes. If I find a way, I'll certainly post a video on it 😉Thanks for watching!

[@MissVirtue35]

Hi Sharon, I have gone through the comments to try to find an answer to this question that I have... however... there's just to many to scroll through. lol and rightly so because your videos are a tremendous help so thank you again! My question is: Once I've created the drop down menu and have successfully linked it to the text, am I able to edit the "IF" statements without creating it all over again. I'm having a difficult time trying to figure this out. Thank you in advance!

[@md2414]

Thank you so much for all your video’s, Sharon!They are also very helpfull in The Netherlands ;) However, because of the editing restrictions it isn’t possible to fill in forms and make remarks at the same time. Do you have a solution for this?

[@SharonSmith]

Hello! It is possible to only lock part of your Word document (so only the form section has to be restricted) and the rest of the document can be edited. I have a video on this: kzbin.info/www/bejne/jqTLZ4eha919eJo Hope this helps! Thanks so much for watching!

[@humbertogalvez2458]

Thanks, Sharon for the video, is very useful, but, if I want to use a check box list instead of drop-down list, what do I have to do? Thanks

[@johnwith-bold7328]

Very Awesome! I am SO excited I found your videos. These seams to be Very Easy to follow. With that said ANY Chance you're available to build 3-4 very simple documents? Seriously, I'm so busy I do not have time. Or is there any chance you have documents for sale anywhere? If I had the keystrokes with a few working examples, I could work my way through it more quickly. Thank you for your consideration

[@SharonSmith]

Hi John! So glad you found my videos helpful! I do have a few form templates available at: www.etsy.com/shop/SharonSmithHR?ref=seller-platform-mcnav that may help you get started. Feel free to email me at [e-mail] if you want to share more details about the forms you are looking to create. Thanks so much for watching!

[@kimviera85]

Great Sharon! Can you tell me how to edit my conditional verbiage after i have protected and unprotected if I need to add/change a formula I speant so much time creating? THANK YOU!

[@jamienimmo6935]

Excellent video and very informative as usual Sharon. What is the best format to save the document, as a Word Template or just a Word document?

[@SharonSmith]

Thank you Jamie! Saving as a Word Template is helpful if you or your users will re-use the form and want to start with a fresh blank form template every time you open a new file. Basically, users can't "save" over a template file type with their filled in answers, they can only "save as" and name the document something new. Hope this helps! Thanks for watching!

[@christinacerqueira4068]

Thanks so much for this Sharon! I was hoping you may be able to help me with something please. I have two dependant dropdowns where I'd like the answer from both to result in text. How can I do this?

[@farestahamohamed835]

very nice

[@SharonSmith]

Thank you for watching!

[@steffanmarx5305]

Hi Sharon, when my formulas work perfectly, how can I use them without having to turn on limited editing on? fantastic video!

[@SharonSmith]

Hi Steffan! This video might be helpful for you related to locking only part of your Word document (restricting only the sections that have form fields) but leaving the rest of the document open to editing: kzbin.info/www/bejne/jqTLZ4eha919eJo Hopefully this helps you out. Thanks for watching!

[@efoster123]

Thanks so much, Sharon! Could you use the same methodology for linked text with checked boxes as well?

[@SharonSmith]

Hi Emily! Great question - I'm researching how to do this. Thanks so much for watching my videos!

[@kylebgc]

This would be amazing if possible with check boxes too! Eg. Auto-filling drug doses and basically anything in a paragraph by quickly ticking through a bunch of check boxes :)

[@esnyde4]

Asking if there has been any sort of update on having the auto-text from a checkbox? That, along with using drop downs, would be incredible for updating my forms!

[@ciarahoddenbach6866]

@@SharonSmith similar to @naelnaz_moosecraft I am using the "legacy controls" and my text still is not showing up. What am I doing wrong?

[@lekcorpuz]

Thank you maam.

[@SharonSmith]

You are very welcome, Alexander! Thanks for watching and subscribing to my channel!

[@samikarouaoui249]

Hi Sharon! Could we use Visual Basic to link TEXT or Image instead of writing the IF {REF} function? Can we put Text + Image in the same row? Could we put an edit box in the IF {REF} function? thank you for your reply, You are the Best ;)

[@bilsan21]

Thankyou Sharon for the great Tutorial. I have a question how can we edit a field code later.

[@SharonSmith]

Hit Alt+F9 (or Alt+Fn+F9) and that will show your field codes if you need to edit them, and hit the same thing to hide them again. Hope this helps! Thanks for watching!

[@alexdelarge2095]

Very well done. Start with an example to show what this is about (unlike most videos where you have no clue if they are even doing what you want), and explain step-by-step. I just wish there was also a quick mention on creating text depending on whether a box was checked or not, since I needed that too. Hopefully google will help with that.

[@SharonSmith]

Thanks Alex! Glad you found it helpful. I have not found a way to do the same with checkboxes yet, but if I do, I'll do a video. Thanks for watching!

[@terryguire1321]

@@SharonSmith Yes, I wondered the same. Thanks for paying attention to your user requests!

[@charlesball9522]

For everyone struggling to get their text to show up. You cannot use a "new controls" version of the text content control boxes, you must use a "legacy" text field (form control) to tab to.

[@tanguerochas]

you can, it just takes some different methods

[@SharonSmith]

Thanks, Charles! Yes, this method requires using legacy tool form fields. Thanks for watching!

[@davidtramsek3722]

@@tanguerochas Where can i find the instructions - link please. Thanks.

[@Naelnaz]

I am using the "legacy controls" and my text still is not showing up. What am I doing wrong?

[@aquarian50]

​@@Naelnazsame with me it does not show

[@SA-zx4qw]

Your videos are the best. Very easy to follow along. Perfect for a project that I am working on. Can you create a video on how to "fix" the coding if you make an error. For instance, I hit Ctrl+9 one too many times and then I was unable to remove the extra set of brackets. Each time I make this error, I have to re-creating the entire coding line from scratch. Thanks!!!

[@SharonSmith]

Thanks so much for your comment. I will try and recreate this issue and see if there is a better fix. Thanks for watching my videos!

[@tfv7809]

Thank you for this easy-to-follow tutorial. Is there a way to edit the text that is auto-populated after making the selection in the drop-down? I have a list of tests that auto-populates a short description and a table to enter scores with test-specific columns/rows but, when I restrict editing, the user is not able to enter the scores into the table.

[@SharonSmith]

Hello! Here is a video that may help you. This shows how you can restrict only parts of your document (so you can leave some sections open for editing): kzbin.info/www/bejne/jqTLZ4eha919eJo I hope this helps you out. Thanks for watching my videos!

[@Savingwithemma]

This is a great video- thank you!! Do you know if there's a way to include a paragraph that uses quotation marks that won't mess with the syntax?

[@SharonSmith]

That is a great question - I'd have to test it, as I'm not sure off hand. Thanks for watching my videos!

[@chris-zu6sf]

Great video! How to make 'Employee Status' invisible, once you select the option? There will also be an 'Undo" button to re-select your options.

[@donaldzentmeyer2037]

Fantastic Videos!! Is it possible to place the inserted picture behind or in front of the existing text? When I try this the picture moves out of the equation.

[@patxmartin]

Great video, would you mind to expand on how to do the same using a check box selection instead of a dropbox? Much appreciated.

[@cassianavieira5766]

I would like to same

[@karolinagrygiel178]

Wow 👏

[@SharonSmith]

Thank you for watching!!

[@fredrickkuiper2988]

Thank you. This was a great video. I wondered how we can do this on desktop Office 365. Thx.

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@toddwindsor8362]

Hi Sharon. I've been trying to find this solution for months. This is EXACTLY what I need!! However... my document needs to have two image fields that will have more than the 25 options allowed in a legacy dropdown. Do you happen to have a video on how you would do the image fields with the ContentControl dropdown (that has an unlimited number of items)?

[@tomasvillarreal3430]

Hey Sharon, thanks a million for this very useful video!!! I have one question for you. I am trying to create a form that will display certain fields (control fields) depending on the selection on a drop down list. In a way, it is basically a drop down list that shows a different template to be filled by user depending on the selection. One example I can give you to better explain my question is, imagine I have a customer deliver document that needs the customer signature due to a modification on a system. The types of modification are Software modification or Hardware modification. The engineer would select for instance, Software Modification, then a set of fields appear and the engineer would populate them accordingly. However, if they select Hardware modification, a different set of fields would appear for the engineer to fill out. Is this possible to accomplish in word ?

[@syedikramullah1114]

Excellent

[@SharonSmith]

Thank you for watching my videos, Syed!

[@syedikramullah1114]

@@SharonSmith welcome Sharon and tnx for teach us .

[@JasonLeeCookMusic]

Thank you Sharon! You're a great instructor, I'm so glad I found your channel! Question - is it possible to have entire tables dependent on fillable forms? For example, I've created a set of dropdown selections in my form and I want a specific set of information to populate onto the form in a table format (e.g. 1x3 table as can be inserted from the Insert tab) for each different option the user chooses. I've tried googling this but perhaps I'm using the wrong terminology because I haven't found good information on it. Thanks again and I'll look forward to your response!

[@SharonSmith]

Hi Jason, thanks so much for watching my videos. I'm glad you find them helpful! I will look into this for you. You can definitely structure your form with tables and have text appear in those tables based on drop down selections. I'll see if I can find some examples. Thanks again for watching!

[@JasonLeeCookMusic]

@@SharonSmith yes I've considered that solution and it may work for some applications but I was hoping to have the tables themselves show up or not depending on drop down selections to avoid having empty tables if certain options are not needed. Thanks for the response!

[@mabel888]

@@SharonSmith Great videos Sharon! I'm wondering the same thing as Jason. I want to populate a pre-created table based on a drop down selection. Is this even possible? Thanks!

[@chrisnaidoo4596]

@@SharonSmith Excellent tutorial videos Sharon! I'm wondering the same thing as Jason and Mabel. I want to invoke a pre-created table per drop down selection of which there can be multiple dropdown selections in my Word fillable form. I'm sure with your great talent, a solution is possible.

[@jasutenliubo]

Thanks for the video! My instructions aren't auto-populating after I press tab. I already have "calculate on exit" checked. Do you know how to solve this issue where the information can be auto-populated after selecting the drop down list options? Thanks again!

[@gbrufau]

Hi Sharon, Thanks for your video. When I insert a picture I only see part of it. Only when I make it very small I see the full picture. Do you know how I can insert a larger picture?

[@beckiclist3910]

Great video! Is there a way to link certain text to the selection from two different dropdowns as opposed to one like this video?

[@paultoumazos9383]

Thank you so much Sharon. This was a brilliantly presented video for such a useful task that many of us always wanted to do. In regardsto link the signatures to the Drop-down entries , I managed to replicate your instructions, but for some reason (unless i stuffed-up), when I used 3 or 4 people => the 3rd and 4th signature was NOT showing. I cut the 3rd and placed it 2nd => and it displayed it OK but then the 2nd which was moved in the 3rd position, it DIDN'T. Would you be kind enough to show us your lights on this. Are you able to have more than 2 "IF" arguments/signatures? Thank youa once again

[@terryguire1321]

@paultoumazos9383 I experienced something similar but I was actually having 9 options in my drop-down. In my case, the failure to display after tabbing wasn't as systematic as yours - where the 3rd and 4th image didn't show - instead it appeared to be random. I wish that Sharon could see what I tried to do and perhaps she's see if I did anything wrong or if there are any special requirements if there are more than 2 IF arguments/signatures.

[@KateDiviney]

This video is great but I am having a few issues in my own application. When I select a drop down field with the intention of other areas being populated, as per the video, it works the first time but then when I try to test the other options to toggle between it either takes a long time or doesn't work and stays stuck on the first one. Any ideas why that may be?

[@adarshc4cool]

Hello Sharon, thanks you for uploading this tutorial. After following the instructions i made my own form. But when i hit tab the text is not appearing automatically. I have to manually right click and select 'update fields' to get the text. how can i make it appear automatically after a selection frm the drop down menu?

[@chris-zu6sf]

How to use a check box selected in ActiveX Controls to program VBA code to make a sentence or table with embedded words appear?

[@jessicapoonsombat7205]

Helpful video. I’m struggling with adding a text box in the coding section. I need to have it so that if the user chooses “yes or no” from the drop down list, a blank text box shows up so that they can fill in *why* they selected that option. Is that possible?

[@alanpritchard3734]

Hi Sharon, sorry for jumping on an old video, but your videos have been really useful to me. Do you have a video similiar to this one but for nested IF statements. i.e. the output text is variable depending on the condition of two separate drop downs? Thank you.

[@SharonSmith]

Hi Alan! Thanks so much for watching my videos! Glad you are finding Ethel helpful. I don’t have a video on this but hoping other videos in my playlist are helpful! Take cate!

[@daniellelockhart511]

Hey Alan just wondering if you’ve figured out the answer to your question yet? (I’m trying to figure this out now!). Thanks!

[@christinacerqueira4068]

Hey Alan, I'm also trying to work this out now. Did you get it sorted out?

[@peteradamka3137]

Hi Sharon! Thank you so much for this incredible video. I have tried out it in some docs but the linked text did not change automatically. I always had to update fields when I put fields codes manually ( opening tab by right click on mouse and then I used "Update field"). Is there any hint to set out automatically? I mean that upon changing the value in drop-down lists, the linked text will be appeared automatically.

[@SharonSmith]

Hi Peter! Do you have the "Calculate on Exit" checkbox in the drop-down form field properties checked? If so, as long as you have another form field for users to tab into, it should auto populate. You also have your form field protected for "filling in forms"? I hope this helps! Thanks for watching my videos!

[@evamartens6186]

Hello, this video was very useful. But I'm trying to link a dropdown choice with a logo (picture) in the header and footer. Is this possible? It doesn't seem to work.I want a dropdown in the header, and depending on what is chosen in the header, the relevant logo has to appear in the footer.

[@ordaudee]

Thanks for this video. The Word version I use is Office 365 and dropdowns don't have a "Bookmark" field setting. How do I do it with Word 365?

[@jrp2355]

Can you do dependent without tabbing? Second text box selected upon the first selection?

[@Tamimolloy]

Sharon, your video has been very helpful but having one issue: Within the text that populates from the drop down selection I need to have an edit box that can be filled in by the user and I have put the { FORMTEXT } box in, however after protecting the document and trying to use it that edit box is not available for the user? Is there another formula I should be using?

[@annazuo225]

Hi Sharon, is there a word limit to the linked text? Is there also a way to edit the texts in the linked field after I've restricted the formatting? Thank you so much for this tutorial! :)

[@SharonSmith]

Hi Anna! There may be a limitation to how many characters in your IF statement, but I recommend to test and see if it works for your needs. You would need to Stop Protection on your form and hit Alt+(Fn)+F9 to see your ref fields and edit them. Then you can re-protect your document. Hope this helps! Thanks for watching!

[@ext4100]

Hello Sharon! What program did you use to record this video? tks

[@jonasnilsson1022]

Thank you so much for all these good and instructing videos Sharon, a real inspiration and so helpful! I have a request for a instruction, I am trying to merge a couple of table forms into one word document, my initial thought and still is my will to try is to have one word document containing all different table forms (8 different forms/templates), where the users choose a specific template in a dropdown list, and then that specific template pops up below the drop down list. The trick is, since I need to restrict the editing to enable the legacy form drop down list, for some reason I cannot include text form fields in the {if {REF}} function. After choosing a specific template in the dropdown list. I need to be able to have "free text" fields in each template. would you be willing to work and show your magic around this request?

[@polychronischouzanas]

Thank you very much for all useful videos!Could I do the same but with a check box?When I click the check box to show a message next to it for example?

[@SharonSmith]

Hello! Unfortunately the functionality doesn’t exist yet for checkboxes. Hoping Microsoft will enhance that sometime. Thanks for watching!

[@polychronischouzanas]

Hi once again! I would like to know if I am able to show text,based on two or more drop down menus using "And" , "or" in my code...would that be possible?

[@lindseyforeman9993]

Excellent video. Question though...how can I include a new or second drop down list WITHIN the text that is linked to the first drop down list? For example, my first drop down is a yes or no answer to Question A, and if yes, I have Question B that shows up and I want a new or second drop down list to show up with the linked text so the user can use it to answer Question B .