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?

Combobox List Drop on Entry
 

Use the OnEnter event for each of the comboboxes (choose the combobox's name
in the top left drop down then the Enter event in the top right drop down in
VBE).

"Daniel A." wrote:

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?

Combobox List Drop on Entry
 

I would have a look at the SUMIF function instead (look in Help).

"Daniel A." wrote:

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?

Combobox List Drop on Entry
 

Thank you! OnEnter worked! Your help is very much appreciated!

"Smallweed" wrote:

Use the OnEnter event for each of the comboboxes (choose the combobox's name
in the top left drop down then the Enter event in the top right drop down in
VBE).

"Daniel A." wrote:

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?