populate values into textbox on userform based on multiple combobox and two optionbuttons

hello
I have this file contains three combobox each other depends on other and I have two optionbutton I would when I select optionbutton (usd) then populate the price in textbox1 from column e for specific item after select from the three combobox and
if i select optionbutton (lyd) then populate the price in textbox1 from column d for specific item after select from the three comboboxes
note: the file contains code if this is not suitable I accept alternative
thanks

First select option1 or 2 then select choose from combo 1 with this code

Please Login or Register  to view this content.

Kind regards
Leo

perfect leo jut i want a little amending if is possible when select option 1 and select item from combobox1 is ok but when I select option2 to the same item nothing change I have to change item to see change

Replace whole code in UserForm code module with the following code.

Please Login or Register  to view this content.

great achievement ! many thanks mr.Jindon ​​​​