View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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?