How do I create a drop down list in a word or excel document?

Open MS Word

Right-click the toolbar & select 'Control Toolbox'

Double-click 'ComboBox' (its added to your project)

Right-click the combobox on the form & choose PROPERTIES

Under NAME choose 'cboNames' (cbo is the prefix used in programming to
represent a combobox)

Right-click the control & choose 'View code'

In the right-hand pane, you'll see two drop down lists. In the left one
choose DOCUMENT & in the right one choose choose OPEN (some code shows below):

Private Sub Document_Open()

End Sub

In between the Sub/End Sub, paste in the following code:

With cboNames
.AddItem ("Sarah")
.AddItem ("Sue")
.AddItem ("Peter")
.ListIndex = 0
End With

Now, your code should look like this:

Private Sub Document_Open()
With cboNames
.AddItem ("Sarah")
.AddItem ("Sue")
.AddItem ("Peter")
.ListIndex = 0
End With
End Sub

The list index property will list Sarah as the selected item in the list.
VBA/VB is 0 (zero) based. Therfore, the first item is 0, second item is 1 and
so on.

Click the green triangle to run (F5) the above code & you should have a
working combobox.

I hope this helps

"wrightvj" wrote:

How do I create a drop down list in a word or excel document?