Комментарии:
Thanks for your very helpful videos. I want drop down list in MS word from a table created already in MS Word or Excel List. How can I accomplish this? Please help
ОтветитьHi! @SharonSmith, Thanks for Helping! I have a Question
Can We create dependent Text fields and Image upload field next to 2nd dependent dropdown. if please send me the code. I'm stuck on it.
Hi Sharon, how about adding a form field that automatically displays the ZIP CODE??
I am extremly grateful to you for making this channel, your way of explaining and smiling is the best. Thank you very much🤩
How many options can be listed for each dropdown, is there a limit?
ОтветитьIs there a way to do a single dd box that populates two drop downs? For example 2 drop downs dependent on one box.
ОтветитьHi Sharon, I have the dependent drop down working. I need to modify the code to add in more options, how do I find the visual basic script and make the changes?
ОтветитьJust spent two days on this and now it's telling me I have a 25 list limitation. Looked around the web, no workarounds... ideas?
ОтветитьThank you for the amazing demo, I have a requirement where I need to update a label based on my dropdown selection. Can you please help me what changes I should make in the code to add any value depending on my dropdown selection
ОтветитьThank you Sharon for sharing this. I have two questions though: 1. Does this method work for Office 365? and 2. How do you get rid of the "5825" Error - as this kept on appearing, in my case as well, each time I was changing the option in my first dropdown form? Best, Anda
ОтветитьThanks for this video. This drop-down list does not work for Farsi language.
persian font is not displayed correctly. Is there a way to solve this issue?
Hello Sharon,
Great video. Is it possible to create these dependent drop downs without the visual basic?
My company restricts the use of macros.
Many thanks for this dropdown. But I am using a template with field (instead of Fill Form) in that it is not working. Could you please help?
ОтветитьPlease, how can I buy this template?
ОтветитьHi Sharon, thanks for this. I am trying to do a contract form/cover letter for several cases, I would like to have a dropdown menu for the title, eg. "Lease" and then have the several references in the document be made to "tenant" and "landlord" just by choosing "Lease", and if I select a different contract title, e.g. "Sale" have these same reference change to "Seller" and "Buyer" within the document, how can I do this? Conversely, I could also use something like having the contract title dropdown command/define all of the text for the rest contract where such references to the parties would be made accordingly. Could you please explain how to do this?
ОтветитьWhat if I don’t have the “bookmark” in the properties section of the drop down to create the bookmark name. It’s a new version on word it think than yours in the video.
ОтветитьThank you for this, it is just what I have been looking for. I would like to expand this to allow two dependent drop down from the initial selection e.g. name in 1st list can select from drop down 2 and 3 but a different name can only chose from drop down 2 and has no option for drop down 3, is this possible?
ОтветитьThanks for this video and all your others! Do you happen to have a video that shows how to do the multi-level dependent dropdown lists using content controls? Or does it work exactly the same way?
Ответитьcan you make o video how to make dependent drop down list using data from excel? in example i want to creat a document in which when i select the person i want to send it will fill automatically some data from excel for this person.
ОтветитьHow to Create a Combo Box Containing More Than 25 Items
ОтветитьMe encantan sus videos, solo que tengo un inconvenientes, deseo colocar mas de 25 item en el segundo cuadro de menú desplegable, pero no me lo permite. Me marca un error de depuración. Existe alguna forma de aumentar los item del segundo combo desplegable. Muy agradecido por sus enseñanzas, están increibles sus videos
ОтветитьHi Sharon, thank you for your video, that’s really helpful!I have a question here: if I need to have a superscript in the drop down menu, do you know how to make that happen? The Word won’t allow me to do that. Thanks!
ОтветитьGreat instruction. I do have a question about saving multiple forms to specific folders. If I do client notes for multiple encounters, can I save each encounter note in a chronological fashion to a specific folder, and how. Perhaps you can refer me to a video that covers this subject. Thank you for your very helpful instruction.
Tim Hughes
Hi Sharon, you are amazing. I have a question though...how does one text wrap a drop down form field? I do hope you can answer this. :/
ОтветитьHi Sharon! Thank you so much for these very useful videos They have been a life saver for my current project. I am trying to learn how to populate a drop down based on two cases. For instance: case "1st shift" + case "1 year of experience" .add "$17.25" Is this even possible?
ОтветитьThanks Sharon for this video. I was able to use your example/template and make edits to my forms. When I showed the updates to my Customers they were so happy.
ОтветитьThanks for such awesome content.
ОтветитьHi Sharon, for the 3rd and final field output box. Can that be replicated in multiple locations? As in I want it to populate DD1 but also have the same population for DD2, DD3 and DD4 that are separate DD's in different areas of the form? hope that makes sense.
Ответитьhello,
just a basic question: how can I get the text written in a legacy plain text control via VBA?
Thanks!
Is there a way to do this using the newer Content control drop down list instead of the legacy forms?
ОтветитьThanks Sharon! I love your videos, you make them so easy to understand and explain it in a way that I didn't get in the MOS class that I took.
ОтветитьCan I have colored text in my drop down? If so how?
ОтветитьGreat video. I have a question regarding repetition. Say you were using the form in your video but you wanted 5 columns for all the same information. Is this possible? For example, you have column 1 that has Region, State and City drop downs. Columns 2, 3, 4, and 5 all would need the exact same information and drops downs. Is this possible? Thanks again. Your videos are so helpful!
Ответитьi wonder is there a way instead of users selecting the 2nd box and 3rd box themselves, it'll auto filled it for them when they select the first box.
I've been digging this around the world.. I don't seems to find this anywhere.
The presentations you give are easily understood. I'm learning so quickly. Thank you!
ОтветитьSharon,
Loved the post. Can’t quite get the calculations to work at each level. Trying to create a form with two levels, i.e., each one with corresponding formulas.
So I've followed the steps and used the provided code as a baseline but I'm having script errors when running it. Is there something flagrantly wrong with this script?
Sub PopulateSubtype2()
Select Case ActiveDocument.FormFields(“Species1”).Result
Case "Core - Faeyr"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dylithar"
.Add "Miaki"
.Add "Tiermalain"
End With
Case "Core - Human"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Akkadian"
.Add "Krimmerian"
.Add "Ennocean"
.Add "Innelain"
.Add "Midian"
.Add "Sutherland"
.Add "Xiao"
End With
Case "Core - Romling"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add “Traditional”
End With
Case "Core - Svar"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dargnan"
.Add "Mordron"
.Add "Kargathi"
End With
Case "Dimi"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Faeyr"
.Add "Romling"
.Add "Spawn: Devourer"
.Add "Spawn: Imbued"
.Add "Svar"
End With
Case "Kith - Chimerian"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Beautiful"
.Add "Fast"
.Add "Powerful"
.Add "Resilient"
End With
Case "Kith - Daemonkin"
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Ash’dren"
.Add "Fel’dren"
.Add "Goblyn"
.Add "Lillian"
End With
With ActiveDocument.FormFields(“Subtype2”).DropDown.ListEntries
.Clear
.Add "Dryad"
.Add "Nereid"
.Add "Oread"
.Add "Salamander"
.Add "Sylphkin"
End With
End Select
End Sub
Hi Sharon! Thank you for your amazing videos! I just have one question, on my dependent drop down, my sentence is too long for one line, am I able to word wrap a Legacy Control, in this case a drop down control? Your help is greatly appreciated!
ОтветитьSharon, thank you so much for this video, it was an opening! However, the list is limited to 25 items, is there a way to have unlimited items on the list?
ОтветитьHi Sharon, great videos! so clear and informative. I have managed to create a dependent dropdown within a larger form I am working on. I have saved this as a .dotm file, all works great for me but when my colleague tested it, she does not get the drop down options. Is there a security step that I have missed? do I need to be able to share the macro?? hope you can help as the form will be great when we get the access fixed. Many thanks
Ответитьcan you show us how you got NewMacros tab on your vb? we're pretty much lost here its just we're not able to get the script to work so you dont something that we didn't catch on your video
ОтветитьHi again Sharon =).
Now I have a difficult challenge for you =). Are you ready?
Do you know if you can create a form where you have two dependent drop down boxes and a free text box below. When you have filled in all the information in the sections above, completely new lines are autogenerated with two dependent drop down boxes and a free text box below, if you want to create a form for several different cases to be handled. Your video is amazing.
Hi Sharon.
Maby you can help me.
I have a word template to save documents, send them with a macro using outlook library.
I want to create a field in my template like the email to field in outlook.
Thaaaaaank you. Amazing
ОтветитьHow can i add multiple entries in a drop down list?
ОтветитьHow can i add multiple entries in a drop down list?
ОтветитьI have tried this and it doest seem to work for me I have no idea what im doing wrong.
ОтветитьNice Explanation
ОтветитьHi Sharon - Is there a way to have three sets of the same multi dependent drop-downs? I've tried copying and pasting as well as creating four additional modules, but the VBC breaks when l I start populating the second set of multi depending drop downs. Thank you.
ОтветитьHi, please help me, i made the form using your example, i use on my computer, it was fine. When i transfer the word doc to my friend pc, it does not operate correctly. Do i have to copy the macro script to the new pc?
Ответить