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

Подписаться 63 тыс.

Просмотров 126 тыс.

50% 1

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

Опубликовано:

26 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@SharonSmith Год назад

Want to take your form-building skills to the next level? 🚀 Checkout my RU-vid Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," ru-vid.com/group/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 RU-vid 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 RU-vid 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 RU-vid 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.

@UniversalFlowTherapy 18 дней назад

Thank you finally I was able to work out how to this after watching this no other videos made sense! 🙏🏻

@SharonSmith 17 дней назад

I'm glad to hear my video helped you! Thanks for watching!

@drthanhtam 3 года назад

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

@SharonSmith 3 года назад

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

@wingame52 2 года назад

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 2 года назад

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

@angelahoward3001 3 года назад

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 3 года назад

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

@simonmccormack605 3 года назад

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

@SharonSmith 3 года назад

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

@mgcservices7524 3 года назад

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 3 года назад

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

@migoram 3 года назад

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 3 года назад

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!

@michaelwilcox1913 2 года назад

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 2 года назад

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

@6tromboner9 3 года назад

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 3 года назад

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: ru-vid.com/group/PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv Thanks so much for watching!

@chilosopher 3 года назад

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

@SharonSmith 2 года назад

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

@ukeitaa 2 года назад

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

@SharonSmith 2 года назад

So glad to hear you found it helpful! Thanks 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!

@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!

@terryguire1321 10 месяцев назад

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

@SharonSmith 10 месяцев назад

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!

@shardagovender4465 3 года назад

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

@SharonSmith 3 года назад

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!

@mariaglezildasoriano7259 3 года назад

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

@SharonSmith 3 года назад

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

@SharonSmith 3 года назад

Be sure to watch this video NEXT on creating multiple levels of dependent drop-down lists: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-54dSJukbe3k.html

@evdelrio 3 года назад

Do you provide services to create/customize Word documents?

@anupriyasaxena5930 Год назад

Is there a way different fillable forms appear based on the selection from drop down option? Ex: when I select drop-down option 1, then fillable form 1 appears. When drop-down option 2 is selected, fillable form 2 appears.

@xiaohan3478 Год назад

Is there a way that I can share this Marco attached word with others?

@lawrencereid 2 года назад

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 2 года назад

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!

@rogangranite 3 года назад

Thank you so much another great video.

@SharonSmith 3 года назад

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

@VijayendranRaghavendran 2 месяца назад

Thank you very much for the video. Very useful.

@SharonSmith 2 месяца назад

Glad you found it helpful! Thanks for watching!

@alielsheikh8091 3 года назад

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

@SharonSmith 3 года назад

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

@sidflashgaminggghacker9223 2 года назад

You are awesome Sharon

@SharonSmith 2 года назад

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

@luismauricio1277 Год назад

Thank You it was very helpful.

@SharonSmith Год назад

Glad you found it helpful! Thanks for watching!

@shareitwithit7323 Год назад

Thank you Sharon it very professional explanation

@SharonSmith Год назад

Glad you found it helpful! Thanks for watching!

@yours.trustworthy 3 года назад

Omg this is extremely good Thanks

@SharonSmith 3 года назад

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

@hermannvalsson4237 3 года назад

Great way to teach thank you.

@SharonSmith 2 года назад

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

@georgiostheodorou9946 3 года назад

Very useful and very unique material

@SharonSmith 3 года назад

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

@sebastianschick1989 3 года назад

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.

@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.

@akulomnarayan6663 3 года назад

Mam ur One of the best presentational videos.

@SharonSmith 3 года назад

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

@Kshais 2 года назад

Nice, thank you!

@SharonSmith 2 года назад

You are very welcome! Thanks for watching!

@abdelouahabelboukhari1078 3 года назад

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.

@ry-tf1mx Год назад

THANK YOU !

@SharonSmith Год назад

You are very welcome! Thanks for watching!

@tansarayut3533 3 года назад

I love this tutorial

@SharonSmith 3 года назад

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

@anniel6458 2 года назад

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!

@cindyklier103 2 года назад

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.

@suresighthomeinspectioninc6540 3 года назад

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 3 года назад

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

@arjavkumar 3 года назад

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

@megathaziq2019 3 года назад

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 3 года назад

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 3 года назад

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!

@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.

@Survdim 3 года назад

🙌You the best

@SharonSmith 3 года назад

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

@anwarmunna3241 Год назад

Thank you so much.....

@SharonSmith Год назад

Thanks for watching!

@mehedihasan-kf4uy 11 месяцев назад

thank you so much

@SharonSmith 11 месяцев назад

Glad you liked it! Thanks for watching!

@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.

@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 8 месяцев назад

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

@aquarian50 8 месяцев назад

@@Naelnazsame with me it does not show

@_tati.tati.tati_ 2 года назад

You enlighten me 😇😇😇

@_tati.tati.tati_ 2 года назад

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?

@juliemalmstrom2869 3 года назад

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?

@alexdelarge2095 2 года назад

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 2 года назад

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 10 месяцев назад

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

@tonyhekopiano5892 2 года назад

Brilliant.

@SharonSmith 2 года назад

Thank you, Tony! Thanks for watching!

@tonyhekopiano5892 2 года назад

@@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.

@mahmoodmajeed6967 2 года назад

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!

@johnwith-bold7328 3 года назад

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 3 года назад

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 Sharon@SharonSmithHR.com if you want to share more details about the forms you are looking to create. Thanks so much for watching!

@steffanmarx1918 3 года назад

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

@syedikramullah1114 3 года назад

Excellent

@SharonSmith 3 года назад

Thank you for watching my videos, Syed!

@syedikramullah1114 3 года назад

@@SharonSmith welcome Sharon and tnx for teach us .

@joshuabees 2 года назад

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!

@lekcorpuz 2 года назад

Thank you maam.

@SharonSmith 2 года назад

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

@farestahamohamed835 3 года назад

very nice

@SharonSmith 3 года назад

Thank you for watching!

@Riodejenny 2 года назад

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!

@karolinagrygiel178 3 года назад

Wow 👏

@SharonSmith 3 года назад

Thank you for watching!!

@beckiclist3910 2 месяца назад

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

@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

@jamienimmo6935 3 года назад

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 3 года назад

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!

@kimviera85 10 месяцев назад

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!

@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!

@MissVirtue35 3 года назад

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!

@lindseyhotz2327 2 года назад

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 2 года назад

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!

@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

@christinacerqueira4068 3 года назад

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?

@canada_boneyfamily9283 3 года назад

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.

@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!

@samikarouaoui249 3 года назад

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 ;)

@md2414 3 года назад

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 3 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xsh6Tk6xJB8.html Hope this helps! Thanks so much for watching!

@emiliojones5983 2 года назад

Thanks a lot for this very helpful tutorial. But i have a question. I want to create a dropdown-list in de Visual Basic Script. i.e. When i select a job title from dropdown-list i want it to show a certain text with a drop-down-list. But when i select the drop-down list, it jump back up to the beginning of the page. Is there a way to fix this?

@wowkid1572 Год назад

Hi Sharon. Is the same set up possible when using the content control option? The list I would like to reference has more than the 25 limit that the legacy options caps out with.

@efoster123 3 года назад

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

@SharonSmith 3 года назад

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

@kylebgc 3 года назад

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 3 года назад

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 6 месяцев назад

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

@beaujuan1186 11 месяцев назад

This is exactly what I needed! Does anyone know how to get data entered from a form like this in word, automatically generated into an excel table?

@SharonSmith 11 месяцев назад

Hello! Here is a video you may find helpful on how to export form data from legacy fields in Word into Excel: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vuddH0Tke0M.html You can build on this concept and set up for the Power Query to get all forms you place into a specified folder. I hope this helps! Thanks for watching!

@donaldzentmeyer2037 2 года назад

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.

@gbrufau 2 года назад

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?

@jessicapoonsombat7205 7 месяцев назад

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?

@Tamimolloy 2 года назад

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?

@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?

@KiranKumar-gb8ux Год назад

Thankyou Sharon for posting such an useful video. But i am stuck at one place and need your help. After putting those programming and restricting the document i am able to edit as I have breaks but once i edit or fill related words in document and give print those additionally filed words don't appear..Can i have a solution for this

@daniellefenton2533 3 года назад

Hi Sharon, if a drop down list has a selection of more than one word, does that affect how you link it? Example, I am trying to link text to "Not Required"' but it will not link although I have checked and the field code is correct. It will work for one selection and not the other.

@JasonLeeCookMusic 3 года назад

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 3 года назад

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 3 года назад

@@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 2 года назад

@@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 2 года назад

@@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.

@evamartens6186 3 года назад

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.

@jasutenliubo 2 года назад

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!

@tomasvillarreal3430 3 года назад

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 ?

@ext4100 3 года назад

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

@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!

@patxmartin 2 года назад

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

@tfv7809 3 года назад

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 3 года назад

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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xsh6Tk6xJB8.html I hope this helps you out. Thanks for watching my videos!

@toddwindsor8362 9 месяцев назад

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)?

@ChantalRivet-sn2tu 3 месяца назад

Hi Sharon, are you able to tell me how you get your formula to show in word? I would like to be able to copy the formula to multiple locations and be able to edit the formula if necessary. (currently once the formula is entered it just shows as blank space until it updates with the selection).

@hawkfb63 2 года назад

Do you know if there is a way to update text like you have done in the "Instructions" area. Except, I would like to use a "Submit" button to build a string. I am hoping to build a string based on 2 drop down list values. For example if Drop down list 1 = Blue, drop down list 2 = Boat, then click submit, and "Blue Boat" would appear. Then Changing the dropdowns to "Red" and Car" and clicking submit a second time would change the string to display "Blue Boat Red Car." I am not sure if this can be done, but any advice is greatly appreciated.

@logmastersrestorations 2 года назад

I can't use Control + F9 or any version of it. When I go to Quick Pick as you showed the long way (since no version of F9 combo is working except to bring up window search) but my version isn't letting me use IF Ref etc.

@jessimacklin8952 8 месяцев назад

Hi Sharon, is it possible to set this up so that when someone selects their dropdown (which has linked text show up) that an additional dropdown shows up? I have a prompt that has 5 dropdown options, each with its own linked text to show up, but if any of the selections are made I am wanting a new dropdown to show to give the same 5 options again.

@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?

@steffie.morris 2 года назад

Will this only work with legacy drop down lists? because then you need to restrict editing on a document to make this work. Or can this also be used somehow with modern dropdown lists?

@gajendrasingh9486 3 года назад

Very help ful video. Can you share formula based word file...can you guide how to take pic like your signature formula...first time i seen auto function in part time & full time employee and signature...very helpful video ....