have a "drop down menu" appear in a data form
 

Need some help. I have a data form that appears when an
employee runs a macro. In one of the cells I want the
user to select from a drop down menu. I only want 12
possible "text entries" (choices) that can be selected.
Is this possible?

have a "drop down menu" appear in a data form
 

You could do it by code:

eg.
Private Sub UserForm_Initialize()
ComboBox1.AddItem "First Item"
ComboBox1.AddItem "Second Item"
ComboBox1.AddItem "Third Item"
ComboBox1.AddItem "Fourth Item"
'...
End Sub

Or you could set the RowSource proeprty of the Combo to an Excel Range.
eg.
Sheet1!A1:A12


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jeff Johnston" wrote in message
...
Need some help. I have a data form that appears when an
employee runs a macro. In one of the cells I want the
user to select from a drop down menu. I only want 12
possible "text entries" (choices) that can be selected.
Is this possible?