With BDD1
v = Controls("moi" & base.SelectedItem.Name).SelectedItem.Index
j = v
If CurrentPanelNo = 0 Then
If v = 0 Then
Controls("PR" & CurrentPanelNo & v & "0") = .Cells(Date1Row, 4 + j)
Controls("PR" & CurrentPanelNo & v & "1") = .Cells(Date1Row, 7 + j)
Controls("PR" & CurrentPanelNo & v & "2") = .Cells(Date1Row, 10 + j)
' etc etc
If v = 1 Then
Controls("PR" & CurrentPanelNo & v & "0") = .Cells(Date1Row, 4 + j)
Controls("PR" & CurrentPanelNo & v & "1") = .Cells(Date1Row, 7 + j)
Controls("PR" & CurrentPanelNo & v & "2") = .Cells(Date1Row, 10 + j)
'etc etc
If v = 2 Then
Controls("PR" & CurrentPanelNo & v & "0") = .Cells(Date1Row, 4 + j)
Controls("PR" & CurrentPanelNo & v & "1") = .Cells(Date1Row, 7 + j)
Controls("PR" & CurrentPanelNo & v & "2") = .Cells(Date1Row, 10 + j)
' etc etc
end if
end if
end if
Partager