lundi 5 octobre 2015

Excell vba code every time i push the command button to paste the data 5 or more rows below , each time

I have an issue which i can't solve.I wrote this code :

Private Sub CommandButton2_Click()

Sheets("sheet2").OLEObjects("CheckBox1").Copy

Sheets("sheet3").Range("V7").PasteSpecial

End Sub

This code copy a checkbox from (sheet 2) to (sheet 3) starting from V7 cell. Now I want the next time I will push command button to paste the data to cell V12,next time to V17 etc. My vba knowledge is not very good as you see.




Aucun commentaire:

Enregistrer un commentaire