I have 3 ComboBoxes and a textbox in a user form. I need to write a code that compares the 3 ComboBoxes and puts the output in the textbox. The 3 ComboBoxes are a list of text and the output would be a number. Example If ComboBox1 Says this and ComboBox2 says this and ComboBox3 says this then TextBox equals this. I also need the Form to update as the user selects options from the ComboBoxes. I can use a command button if I have to but I just need to know what I need to write to bring everything together.
Solved by E. J. in 30 mins