Private Sub CommandButton1_Click()
If textbox1 <> "" Then
If IsNumeric(textbox1) Then
With Range("Ab3").Resize(, Val(textbox1))
.EntireColumn.Insert Shift:=xlToRight
.Offset(, Val(textbox1) * -1).Rows(3).Value = "intérimaire"
End With
End If
End If
Unload Me
End Sub