Hi,
In the ComboBox1_Change event change TextBox7 to

TextBox7 = Format(MyRange.Find(ComboBox1).Offset(0, 8), "dd/mm/yyyy")