I have an issue which i can't solve.I wrote this code:
This code copy a checkbox from (sheet 2) to (sheet 3) starting from V7 cell. Now I want the next time I press the command button to paste the data to cell V12,next time to V17 etc. My vba knowledge is not very good as you can see.![]()
Private Sub CommandButton2_Click() Sheets("sheet2").OLEObjects("CheckBox1").Copy Sheets("sheet3").Range("V7").PasteSpecial End Sub
Bookmarks