将数据从工作表调用到userform

so i have a ComboBox(ComboBox1) and from this ComboBox I would put a SO#(SalesOrder#) and click on an update button, when i click on this, the following fields would fill up according to the SO#(SalesOrder#) : TextBox1, ComboBox2, TextBox2, TextBox8, ComboBox5, TextBox4, TextBox5, ComboBox3, ComboBox4, ComboBox6, and TextBox7.so i have a ComboBox(ComboBox1) and from this C