populate values into multiple textboxes based on optionbutton & combobox

[Alaa-A]

good morning !
I wantto populate the values into all of the textboxes . if I select option button $ and the item from combobox based on column B ,then should populate the values (column B=textbox1,column C= textbox2, column D=textbox3) . as to textbox4=textbox2 * textbox3
the same thing if I select option button € and the item from combobox based on column B ,then should populate the values (column B=textbox1,column C= textbox2, column E=textbox3) as to textbox4=textbox2 * textbox3
thanks

[jindon]

To UserForm1 code module

Please Login or Register  to view this content.

[Alaa-A]

perfect ! just I need fixing some problems if you have time . when I select optionbutton $ and the item from combobox it will populate the values but if I select optionbuttin € for the same selected item into combobox it doesn't change the values . I have to run again the userform from the beginning to populate the values and if I would show numberformat into textbox4 it will populate mismatch error in this line

Please Login or Register  to view this content.

I use this

Please Login or Register  to view this content.

for each textbox but the problem in textbox4 . may you make it by change automatically when select from optionbutton to another and fixing numbers formatting .

[jindon]

Please Login or Register  to view this content.

[Alaa-A]

many thanks for your solution & assistance