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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
referencing a Drop Down Menu 1
drop down menu 1
Set Column choice to a variable from a Drop Down 4
Data Validation List (conditional) 2
Drop down menu / list 3
Drop down menus 2
Drop Down List and macros 3

Back
Top