+ Reply to Thread
Results 1 to 3 of 3

Excel VBA: If (userform) Checkbox 1 = True, copy data from sheet 1 range x - sheet 2 rng y

  1. #1
    jjward101
    Guest

    Excel VBA: If (userform) Checkbox 1 = True, copy data from sheet 1 range x - sheet 2 rng y

    Hi. I hope the title conveys what i am trying to do, and hitting a brick wall with.

    I have a userform where i have placed 20 checkboxes. If Checkbox 1 is checked,
    i would like the info in A1 on Sheet 1 to be copied to the next empty row on Sheet 2, starting at Row X.

    I have searched, but cannot find anything that works, and everything i have tried has failed miserably.

    Can anyone point me in the right direction?

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel VBA: If (userform) Checkbox 1 = True, copy data from sheet 1 range x - sheet 2 r

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    jjward101
    Guest

    Re: Excel VBA: If (userform) Checkbox 1 = True, copy data from sheet 1 range x - sheet 2 r

    This does not seem to be working...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 08-03-2017, 04:31 PM
  2. Replies: 6
    Last Post: 01-30-2017, 03:07 PM
  3. ActiveX CheckBox True or false send value to other sheet cell value and add data
    By PatrikOslo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2016, 11:04 AM
  4. [SOLVED] Use checkbox on sheet ('true' or 'false') to decide if run macro
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 09:12 PM
  5. Replies: 1
    Last Post: 09-17-2013, 01:38 PM
  6. [SOLVED] Excel VBA- copy data from userform to sheet 1 with a new row each time
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 09:54 AM
  7. ActiveX Checkbox = True then Copy 2 cells to other Sheet
    By kyros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2012, 07:49 AM

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