How to create drop down list in word
For example, if you're creating a drop-down menu that contains a list of sports, type "baseball" in cell A1, "basketball" in cell A2, "football" in cell A3, and so on. I have created a several combo boxes form control in my spreadsheet and in the format control, set the input range by selecting a range of cells from Sheet 2 of my document.
You are commenting using your Twitter account. You are commenting using your Facebook account.
How to Easily Create a Drop-down List in Your Word Document
Notify me of new comments via email. Notify me of new posts via email.
Create a free website or blog at WordPress. MS Word Know How. To enable the Developer tab Word 1.
How to Create a Drop-Down Box in Microsoft Word
This step is applicable to all other controls as well. To stop protection 1. In the similar way, you can keep adding items to the list. Enforce protection to the document, so that list values cannot be modified. To insert an ActiveX Control check box 1. Click Design Mode to disable. The check box is now clickable. Insert text fields 1. A combobox is created at the cursor position.
In the dialog box, under the section Generalenter a Title of the combobox. In the dialog box, under the section Drop-down List Propertiesclick the Add button. Add Choice dialog box appears. Enter a display name and value for the first list item.
Click Add again to enter a second list item. You can keep adding as many item as you need. July 27, at 7: June 14, at 9: January 20, at 7: September 21, at 2: September 30, at 7: May 15, at 7: February 12, at 3: December 24, at 6: December 29, at 5: February 9, at October 16, at 3: August 21, at 3: August 21, at 6: May 9, at 1: May 9, at 5: February 24, at Click directly on the cell in your spreadsheet in which you want the drop-down list to appear. Click on the "Data" button, and select "Data Validation. Click on the "Settings" tab, then select "List" from the "Allow" drop-down menu.
Go to the "Source" box, and type an equals sign, followed by the name you chose for your drop-down list. Place a checkmark next to "Ignore blank" if you want to provide users with the option to select none of the items in your drop-down list.
Creating a drop down list in Excel: static, dynamic, from another workbook
Place a checkmark next to "Show error alert after invalid data is entered. If you want users to have the ability to enter their own data into the drop-down list, then omit the checkmark from this field. Open the Excel file in which you want a drop-down list created.
Enter a list of items you want displayed in your drop-down list. Each item should be entered into its own separate cell in just one column.How to populate a dependent dropdown list in Word
For example, if you're creating a drop-down menu that contains a list of fruits, type "apple" in cell A1, "banana" in cell A2, "blueberry" in cell A3, and so on. Select the cell range that contains all the drop-down items you entered. Click within the "Name" box in your Excel toolbar, which is located to the left of the formula bar.
Type a name that describes the drop-down items into the "Name" box, then press "Enter. Navigate to and click on the cell in your Excel document in which you want the drop-down list to display. The drop-down is added to the Word page. Click the "Properties" button in the Controls section of the ribbon, opening the "Content Control Properties" window.
Enter information into the window's fields to customize your drop-down box as desired, such as choosing the drop-down box's title and color.
Set optional controls for editing or deleting within the drop-down list, as desired. Here is where you type all of the items users can select from in the list.
Enter the "Display Name" for each individually, and the Value field is autopopulated. The first step is to create the user form and add a couple of form fields, as follows:. If you're still using Wordthe instructions are similar, but you'll need to display the Forms toolbar to access the controls. To do so, choose Toolbars from the View menu, and then select Forms. Now you're ready to populate the first dropdown with the region items, as follows:. Next, right-click the state dropdown field and name it ddState using the Bookmark control, as you just did to name the first dropdown ddRegion.
Click OK to close the dialog box. At this point, you have one populated dropdown named ddRegion and a second dropdown named ddState, that's still empty. To populate ddState, add the VBA procedure below, as follows:.
You need to tell the state dropdown to execute the new procedure you just added, as follows:. All that's left is to use the fields. Click the region field's dropdown and choose South. Doing so executes the sub procedure macro PopulateddStateswhich populates the state dropdown with Georgia and Texas.