below code put in userform initialize but error show is type mismatch. what is correct code Me.ComboBox1.RowSource = Sheet2!Range("a1:a8").Value