Combo Box Dependent.

Hi,

Workbook attached.

In user form ‘uf_SelectCurrency’ I have two combo boxes,

i). cmb_ER_FPS_Curr = picks data from Dynamic Range - ‘CountriesRange’
ii). cmb_ER_FPS_CurrCode = picks data from Dynamic Range - ‘CurrCode’

Once the user form initializes, I want a code that does the following

If the user selects value from combo box labeled ‘Currency’ (‘cmb_ER_FPS_Curr’) then,

Combo box labeled ‘Currency Code’ (cmb_ER_FPS_CurrCode) should automatically get populated with corresponding value of the selection in ‘Options’ sheet. & the combo box ‘Currency Code’ should be disabled.

and Vice Versa

Thanks
R

Why not have two columns in the ComboBox or use a Listbox?

Also, your named ranges in the sheet have #Ref errors

I've amended your existing code

Please Login or Register  to view this content.