View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel A.[_2_] Daniel A.[_2_] is offline
external usenet poster
 
Posts: 4
Default Combobox List Drop on Entry

Hello...I created a userform with several text boxes and three comboboxes
with lists which pull from a named list range elsewhere in the workbook. I
was able to get the first list to drop on entry using:
"Private Sub UserForm_Activate()
Entity.DropDown
End Sub"
However, I have two more comboboxes with lists which I would like to drop
down on entry as I tab into the field. They are separated (in terms of
order) by textbox fields, if that makes a difference. Does anyone know how I
can do this?