I have an sheet with information like the one below. I have a combo box set up with the info on a form. I can't get the form to display the correct information from the sheet when I change the combo box value to 2000 it is staying at the default 1000 value.
Example Sheet Below
Data Value1 Value 2 Value 3 Value 4 1000 0.5 0.75 1 1.25 2000 0.6 0.66 0.72 0.78 3000 0.7 0.8 0.9 1
So what i need to show is when i load up the combo box with the Data Value the Value 1, Value 2 ect all change to the correct value.
Hope that's correct, difficult to explain. I have done it before a long time ago and can't remember and can't seem to find a video on how to do it again.