Hello Forum
Hello every one
Please if you can help me to solve this problem
In my UserForm i have ComboBox1 and ComboBox2 and TextBox1
ComboBox1 is powered by "JUNIOR" and "SENIOR"
ComboBox2 is powerd by numbers ( 0-1-2-3-4-5 )
I have 3 different cases :
1 - If ComboBox1 = "JUNIOR" the value in TextBox1 will always without seeing ComboBox2 = ("00.00")
2 - If ComboBox1 = "SENIOR" and ComboBox2 = 0 the value in TextBox1 = ("100.00")
3 - If ComboBox1 = "SENIOR" and ComboBox2 > 0 (12345) the value in TextBox1 = ("400.00")
when I make the choice in ComboBox 1 and I choose a number in ComboBox2 .. and always i change by ComboBox2 this code in my UserForm work perfectly
My Problem is :
For example I'm with the first case .. ComboBox1 "JUNIOR" and the number 3 in ComboBox2 ans value ("00.00") in TextBox1 ..Now at this moment suddenly
if i change the choise in ComboBox1 to "SENIOR" ..the value in TextBox1 does not automatically change to ("400")
I want the value in text automatically changes wherever I type
Thank you in advance for help me
Cordially
MARTI MARTI
USERFORM.xlsm
Bookmarks