ComboBox when external value change other combobx return Value

Hi EF User's!, good morning!!

I have this macro:

Please Login or Register  to view this content.

The combobox8 returns an employee number one external worksheet. The range of employee number ​​is A2:A.
Just want you in combobox9 put the "Employee Name"( Range B2:B and the same worksheet) when selecting combobox8 value.

someone could help me?

Best Regards!!

Try this...

Please Login or Register  to view this content.

Hi Alphafrog, thanks!! but doesn't work , I need when the combobox8 select an employee number (A2:A) return the "Employee Name" in the combobox9 ( B2:B and the same worksheet)..
Any idea Alpha?
Thanks a lot!

Use my previous code to populate the two comboboxes.

The code below will select the employee name in combobox9 when you select a number in combobox8

Please Login or Register  to view this content.

This will select an employee number in combobox8 when you select a Name in combobox9.

Please Login or Register  to view this content.

Wwow!

Works Great!!

It's the final code for ExForum User's:

Please Login or Register  to view this content.

In combobox8:

Please Login or Register  to view this content.

In Combobx9:

Please Login or Register  to view this content.

!! Thanks AlphaFrog!,

You're welcome.

Alternatively, you could simply populate combobox8 with two columns; the employee number and name.

Please Login or Register  to view this content.

it's much better Sr!

Works Great!!..

Thanks again AlphaFrog!!
Regards!