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?

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?

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?

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?