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 55 56 57 58 59 60 61
| Sub Nouvelle_Ligne()
Dim chk As CheckBox
Dim vcell As Range
Dim vrai As Range
ActiveCell.Range("A1:H1").Select
Selection.Insert Shift:=xlDown
ActiveCell.Offset(-1, 1).Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A2"), Type:=xlFillDefault
'ActiveCell.Range("A1:A2").Select
ActiveCell.Offset(0, 3).Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A2"), Type:=xlFillDefault
'ActiveCell.Range("A1:A2").Select
ActiveCell.Offset(0, 1).Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A3"), Type:=xlFillDefault
'ActiveCell.Range("A1:A3").Select
ActiveCell.Offset(0, 1).Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A3"), Type:=xlFillDefault
ActiveCell.Offset(0, -6).Select
Selection.Copy
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
ActiveCell.Offset(0, 7).Select
' ActiveCell.Range("A1:A3").Select
Application.ScreenUpdating = False
For Each vcell In Selection
vcell.Select
Set chk = ActiveSheet.CheckBoxes.Add(30, 69, 0, 0)
With chk
.Text = ""
.Value = xlOff
.ShapeRange.Left = ActiveCell.Left
.ShapeRange.Top = ActiveCell.Top
.LinkedCell = ActiveCell.Range("P1").Address
.Display3DShading = True
End With
Next
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$T$3:$T$33"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
ActiveCell.Range("A2").Select
End Sub |
Partager