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

  • Thread starter Thread starter Jeff Johnston
  • Start date Start date
J

Jeff Johnston

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?
 
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
 
Back
Top