Set xDirection = ActiveDocument. Then go ahead exactly as we provided in the article to finish the whole settings.įor i = 1 To For the third group of the dependent drop-down lists, please get into each drop-down list's Properties window and specify the Bookmark as ddfood3 and ddCategor圓 separately 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 Ģ. 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 Ģ. In the step 4 and 5 we mentioned in the article, now you need to do the following changes:ġ. The Track changes option prevents other Word users from creating untracked changes in the document.
CREATING A DROP DOWN MENU IN WORD FOR MAC CODE
If you need all dependent drop-down lists take effect, please apply the below VBA code and do the below settings: Choose the type of editing you want to allow from the drop-down menu: Tracked changes, Comments, Filling in forms, or No changes (Read only). This can be done by selecting the file menu on the Ribbon, (a) navigating to O ptions, (b) selecting Customize Ribbon on the left hand side of the new window that opens up, (c) and selecting the Developer checkbox. Supposing you have three groups of dependent drop-down lists in your document. In order to make us of the drop-down list feature in Microsoft word the Developer tab needs to be enabled on the ribbon. When selecting Fruit from the first drop-down list, only the fruit categories can be selected in the second one. Now the dependent drop-down lists are created.
CREATING A DROP DOWN MENU IN WORD FOR MAC PASSWORD
In the Restrict Editing pane, you need to:ġ0.1), Check the Allow only this type of editing in the document box ġ0.2) Select Filling in forms option from the drop-down list ġ0.3) Click the Yes, Start Enforcing Protection button ġ0.4) In the Start Enforcing Protection dialog, enter the password and click the OK button. Now click Developer > Restrict Editing as below screenshot shown.ġ0.
In the dialog box, please select the above Macro name (here is Popolateddfood) from the Exit drop-down list, and then click the OK button.ĩ. Right click the first drop-down list and click Properties to open the Drop-down Form Field Options dialog box. Save the code and go back to the document.Ĩ. ddfood and ddCategory should match the Bookmark options you entered in the above two Drop-down Form Field Options dialog boxes.ħ. In the code, please change items under each case as you need.Ģ. If ((xDirection Is Nothing) Or (xState Is Nothing)) Then Exit Subġ. Set xState = ActiveDocument.FormFields("ddCategory") Click a cell where you want to insert the drop down list, then click Data. Set xDirection = ActiveDocument.FormFields("ddfood") Next, to create a list of unique entries, enter the word Can in cell C2. VBA code: Create dependent drop-down list in Word Sub Populateddfood() In the Microsoft Visual Basic for Applications window, click Insert > Module, then copy below VBA code into the Module window. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ħ. Right click the second drop-down list, click Properties to open its Drop-down Form Field Options dialog box, and in the dialog, enter ddCategory into the Bookmark box and click the OK button. In the opening Drop-down Form Field Options dialog box, you need to:ģ.1 Enter the category into the Drop-down item box and then click the Add button, repeat the operation until all categories are added to the Items in drop-down list box.Ĥ. Right click the first drop-down list (this drop-down list should be the parent one), and click Properties. Click Developer > Legacy Forms > Drop-Down Form Field. Firstly, you need to insert two drop-down lists in your Word document.
Please follow the instruction step by step.ġ. The below VBA code can help you creating dependent drop-down lists in a Word document. As the left screenshot shown, you need to limit the choices in the second drop-down list based on the option in the first drop-down, how can you do? This article will show you method to create dependent drop-down lists in Word document.Ĭreate dependent drop down lists in Word with VBA code To give users the ability to select more than one value from a list box, use a Multiple-Selection List Box.Place the cursor in the form where you want the multi-selection list and then go to the Controls Task Pane (View > Design Tasks > Controls).Under the Repeating and Optional section, click Multiple-Selection List Box.
Click the little drop down arrow to access the default bullets in the Bullets Library. On the Home tab of the Ribbon, go to the Paragraph group where the Bullets command is located. Now, you can see that recorded macro will appear on the Quick Access Toolbar. Click on the Stop Recording Macro from the drop-down menu.
Step 8: Now, click on the View tab and click on the Macros drop-down menu.
0 kommentar(er)
