- How to create drop-down lists in Excel on Mac
- How to Create a Fillable Form In Word for Windows
- Thank you for your feedback!
Am I supposed to create a Macro to run on exit? The required macro is already in the document. All you need do is make a selection then exit the dropdown.
Still not working. I make a selection, then click elsewhere in the document and nothing happens. I also tried pressing "tab" and nothing happens. I see the empty "client details" field underneath but it never changes. I enabled marcos when opening it. See screen caps. Attached Images Screen Shot at 6.
Your PC version opens as read-only because the product has not been registered; I don't know why it's not working on the Mac, because MS is supposed to have added content control support to Word for the Mac. I've tried going with the alternative ie. I want all text to remain editable.
How to create drop-down lists in Excel on Mac
Is there a way to do this? That is to say, have drop-down fields that trigger the creation of text in IF formula fields while keeping the whole document editable? With formfield protection, you can use Section breaks to delineate which parts of the document will be protected i. You can achieve a reasonable level of granularity with multiple Section breaks.
Brilliant, thanks! Last question: How to I create multiple IF statements in one field? It doesn't update when I go "update field". Unless there is a particular reason for nesting the fields, e. Affiliate disclosure: TechRepublic may earn a commission from the products and services featured on this page.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. What's Hot at TechRepublic Python is eating the world: How one developer's side project became the hottest programming language on the planet Photos: The latest Raspberry Pi alternatives for you to try How to fail as a data scientist: 3 common mistakes Samsung Galaxy Note A cheat sheet.
Microsoft Weekly Newsletter Be your company's Microsoft insider with the help of these Windows and Office tutorials and our experts' analyses of Microsoft's enterprise products.
Delivered Mondays and Wednesdays Sign up today Sign up today. Editor's Picks. Python is eating the world: How one developer's side project became the hottest programming language on the planet. How iRobot used data science, cloud, and DevOps to design its next-gen smart home robots. Beyond the PC: Lenovo's ambitious plan for the future of computing. Straight up: How the Kentucky bourbon industry is going high tech.
Hide Comments. My Profile Log Out. I have used the code above and works well, but only for one box.
What do I do in the code if for example if I need to select up to 3 fruits once I have selected the Fruit group? I am duplicating the field I created but only one works. Is there a way to add multiple category fields based on the one selection? I followed instructions above and works well on one field with one other dependent field only. But I need 5 dependent fields, all the same triggered by the one field in this case "wine".police-risk-management.com/order/calls/dipe-microfono-spia-per.php
How to Create a Fillable Form In Word for Windows
I duplicate the drop-down field it doesn't work, I am trying to add a second field to the code, but not sure how: ActiveDocument. FormFields "ddCategory" and "ddCategory2". HI I got the drop downs to work. I have a question When I make the selection for the first drop down, Is there any way to automate the coordinating and related selections for the following drop downs? For example. I have a parent drop down Attorney, the two child drop downs are Title and Phone number respectively.
When I select the attorney name, I would like the related child drop downs to auto populate the title and phone number. How would I be able to do that? Thanks in advance. Good day, Sorry can't help you with that yet. Thanks for your comment.
Hi, How do we text wrap? I followed the step and it works fine except that when the second list is too long, it goes beyond the page. Is there a way to have it automatically wrap? Hi Paul, Sorry can't help you with that yet.
Thank you for your feedback!
Hi There, are there restrictions with the name in the field e. Hi Marc, Yes, there are restrictions with the name in the field. Hi mary, Which version do you mean? Can you add this to multiple areas on a single page consisting of multiple sections? I was able to successfully complete the process in one section of my document, but when I attempt to complete the same process while on the same page, but in a different section of my document and with new drop down options, only my first added boxes are working, not the ones in the second section..
Hi ingrid, Supposing you have three groups of dependent drop-down lists in your document. If you need all dependent drop-down lists take effect, please apply the below VBA code and do the below settings: In the step 4 and 5 we mentioned in the article, now you need to do the following changes: 1. For the first group of the dependent drop-down lists, please get into each drop-down list's Properties window and specify the Bookmark as ddfood1 and ddCategory1 separately; 2. For the second group of the dependent drop-down lists, please get into each drop-down list's Properties window and specify the Bookmark as ddfood2 and ddCategory2 separately; 2.