Results 1 to 8 of 8

Copy Check Box to Every 5th Cell with Command Button

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    larisa
    MS-Off Ver
    2010
    Posts
    4

    Copy Check Box to Every 5th Cell with Command Button

    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 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.
    Last edited by und3raxi; 10-07-2015 at 04:05 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can't copy a locked cell when there is a command button with a macro attached to it...
    By danielneedssomehelp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2014, 12:48 PM
  2. [SOLVED] command button vba to copy formula from cell above
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2014, 07:29 PM
  3. [SOLVED] macro for command button to copy cell content to other cells
    By Emma_B in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 06:32 AM
  4. copy and paste data from one worksheet cell to another using command button
    By jasonruiz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2011, 04:34 AM
  5. Uncheck Check Box + check a option button using Command Button
    By Carlsbergen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2009, 03:09 AM
  6. Copy cell value to list with command button click
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2008, 02:48 PM
  7. Command Button to copy conetents of one cell to another
    By Gazzauk2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2005, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1