1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| ' Ligne 01
Me.txtLib1 = .Cells(RecordNumber, 20)
Me.cboUnit1 = .Cells(RecordNumber, 21)
Me.txtQte1 = .Cells(RecordNumber, 22)
Me.txtPUHT1 = .Cells(RecordNumber, 23)
Me.txtPTHT1 = .Cells(RecordNumber, 24)
Me.txtSTHT1 = .Cells(RecordNumber, 25)
' Ligne 02
Me.txtLib2 = .Cells(RecordNumber, 26)
Me.cboUnit2 = .Cells(RecordNumber, 27)
Me.txtQte2 = .Cells(RecordNumber, 28)
Me.txtPUHT2 = .Cells(RecordNumber, 29)
Me.txtPTHT2 = .Cells(RecordNumber, 30)
Me.txtSTHT2 = .Cells(RecordNumber, 31)
' Ligne 03
Me.txtLib3 = .Cells(RecordNumber, 32)
Me.cboUnit3 = .Cells(RecordNumber, 33)
Me.txtQte3 = .Cells(RecordNumber, 34)
Me.txtPUHT3 = .Cells(RecordNumber, 35)
Me.txtPTHT3 = .Cells(RecordNumber, 36)
Me.txtSTHT3 = .Cells(RecordNumber, 37)
'
'
'
'
'
' Ligne 27
Me.txtLib27 = .Cells(RecordNumber, 176)
Me.cboUnit27 = .Cells(RecordNumber, 177)
Me.txtQte27 = .Cells(RecordNumber, 178)
Me.txtPUHT27 = .Cells(RecordNumber, 179)
Me.txtPTHT27 = .Cells(RecordNumber, 180)
Me.txtSTHT27 = .Cells(RecordNumber, 181)
' Ligne 28
Me.txtLib28 = .Cells(RecordNumber, 182)
Me.cboUnit28 = .Cells(RecordNumber, 183)
Me.txtQte28 = .Cells(RecordNumber, 184)
Me.txtPUHT28 = .Cells(RecordNumber, 185)
Me.txtPTHT28 = .Cells(RecordNumber, 186)
Me.txtSTHT28 = .Cells(RecordNumber, 187)
' Ligne 29
Me.txtLib29 = .Cells(RecordNumber, 188)
Me.cboUnit29 = .Cells(RecordNumber, 189)
Me.txtQte29 = .Cells(RecordNumber, 190)
Me.txtPUHT29 = .Cells(RecordNumber, 191)
Me.txtPTHT29 = .Cells(RecordNumber, 192)
Me.txtSTHT29 = .Cells(RecordNumber, 193)
' Ligne 30
Me.txtLib30 = .Cells(RecordNumber, 194)
Me.cboUnit30 = .Cells(RecordNumber, 195)
Me.txtQte30 = .Cells(RecordNumber, 196)
Me.txtPUHT30 = .Cells(RecordNumber, 197)
Me.txtPTHT30 = .Cells(RecordNumber, 198)
Me.txtSTHT30 = .Cells(RecordNumber, 199) |
Partager