Populate Userform Listbox or Combobox. Do you have ad- blocking software enabled? Please consider excluding this website from blocking or turning off the blocker while browsing this site. Install Real Vnc Viewer Ubuntu Iso.

This Microsoft Word Tips & Microsoft Word Help page demonstrates several methods that you can use to populate a userform listbox (or combobox). Microsoft Word MVP Doug Robbins has kindly assisted with the preparation of this page.

Thanks Doug! Notes: 1. See my Create & Employ a Userform tips page for information on creating and employing userforms. The basic process for populating a listbox or combobox is the same. You can download the demonstration document containing all of the example userforms and VBA procedures used to prepare this tips page with the link at the end of the page. Review. A listbox provides users with a convenient means  of selecting one or more items from a fixed pre- defined list. A combobox provides users with a compact and convenient means of selecting a single item from a pre- defined list.

What version of SQL Server do I have? This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other. As an Office 365 subscriber, you regularly get new and improved Office 2016 features. See what's available to you today.

Simple List. In its simplest form, a listbox could be used for responding to simple yes or no questions. The code for populating a listbox is normally placed in the userform . For example, the list of U. S. Fortunately you can use the more versatile . The user will select his or her state name from the list but the result in the document will be the state abbreviation. The code for populating the listbox shown above and for displaying the result in the document is provided and explained below: VBA Userform Script: Option Explicit.

Private Sub User. Form. Note columns are indexed . Next we will look at some methods for using an external data source to populate a listbox. Word table. The first method uses a Microsoft Word table contained in a separate document as the external source. Word MVP Doug Robbins has posted this method regularly in the Microsoft Word Public newsgroups. Example 1 - The following series of illustrations show: An example of the source file table.

How the source data is displayed in the userform. How the selected list item is displayed in the document. The code for populating the listbox and displaying the results.

For this example, I used a source document saved as . Note . Bound. Column indexed starting at 1. The . Column property is, in my opinion, the easiest method. In this case you collect the data from the source as previously shown and then hide all but the primary data. For this example, I used a source document saved as . Late Binding. The third Excel method uses the DAO object (similar to the Access method) to retrieve Excel data: VBA Script: Private Sub Userform. See the MVP FAQ: Load a Listbox from a Name Range in Excel using DAO for a detailed discussion of the above method and its advantages.

See my addendum tips page:  Populate Userform Listbox From XML Source for a method of retrieving data from an XML source file. Cascading Listboxes. In the following examples I demonstrate a few methods for populating secondary and tertiary listboxes based on the value chosen in a parent primary listbox.

In the listbox depicted below, the list members displayed in the secondary . The list displayed in tertiary . Here is an . If you are interested in something this deep then contact me via the website feedback. Multi- Select Listbox. Wrapping it up, I will close with a few examples for demonstrating multi- select listboxes. A lot of people get tripped up using the Listbox. Selected property.

In the following example the user is asked to choose their two favorite sports from a list. Code in the List. Box. Please de- select an item to continue. I hope you have found this tips page useful and informative.

If you are a teacher searching for educational material, please visit PBS LearningMedia for a wide range of free digital resources spanning preschool through 12th grade.