Private Sub Combobox1_Click()
Dim lign As Long
If ComboBox1.Value <> "" Then
lign = ComboBox1.ListIndex + 6
TextBox1.Value = format_textbox(Range("A" & lign))
TextBox2.Value = format_textbox(Range("C" & lign))
TextBox3.Value = format_textbox(Range("D" & lign))
TextBox4.Value = format_textbox(Range("E" & lign))
TextBox5.Value = format_textbox(Range("F" & lign))
TextBox6.Value = format_textbox(Range("G" & lign))
TextBox7.Value = format_textbox(Range("H" & lign))
TextBox8.Value = format_textbox(Range("I" & lign))
TextBox9.Value = format_textbox(Range("J" & lign))
TextBox10.Value = format_textbox(Range("K" & lign))
TextBox11.Value = format_textbox(Range("L" & lign))
TextBox12.Value = format_textbox(Range("M" & lign))
TextBox13.Value = format_textbox(Range("N" & lign))
TextBox14.Value = format_textbox(Range("O" & lign))
TextBox15.Value = format_textbox(Range("P" & lign))
TextBox16.Value = format_textbox(Range("Q" & lign))
TextBox17.Value = format_textbox(Range("R" & lign))
TextBox18.Value = format_textbox(Range("S" & lign))
TextBox19.Value = format_textbox(Range("T" & lign))
End If
End Sub
Private Function format_textbox(rng As Range)
res = Replace(rng.Value, ".", ",")
res = Format(CCur(rng.Value), "### ### ##0.00")
format_textbox = res
End Function