Results 1 to 11 of 11

How to copy a table including its checkboxes from one worksheet to another

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2017
    Location
    North Carolina
    MS-Off Ver
    2013
    Posts
    29

    How to copy a table including its checkboxes from one worksheet to another

    Hello all,

    I have created a userform that populates a preexisting table on a worksheet. This table contains ActiveX checkboxes in various locations. When the user submits the userform, the data is transferred to the table, including whether to "check" the checkboxes or leave them blank. That portion works properly. The vba code for the userform then needs to copy the completed table to another worksheet. This is where I am running into issues. The code is a simple row copy and paste at the bottom of the second worksheet:
    Sheet46.Rows("2:22").Copy
    Sheet3.Activate
            
            Dim lastRow As String
    
            lastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row + 4
            Range("A" & lastRow).Select
            Selection.PasteSpecial
    But this does not copy or paste the various checkboxes. Do I need to link the checkboxes to a specific cell for them to be copied? If so, how do I do that? If it helps to have an example, one checkbox is named CenterfireCheckBox and is located roughly over cell W7. Its location in the original table is Top = 117, Left = 220.5.

    Any thoughts would be greatly appreciated!
    Last edited by jrooney7; 08-19-2018 at 05:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy duplicates including first instance to another worksheet
    By Newbikonob1 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 01-23-2016, 11:41 AM
  2. Copy duplicates including first instance to another worksheet
    By Newbikonob1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2016, 10:30 AM
  3. [SOLVED] how to copy worksheet including headers & footers
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2014, 06:41 AM
  4. Copy entire worksheet including all colors
    By Trevorrow in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2013, 01:45 PM
  5. Copy worksheet including named ranges not including macros
    By urungus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2009, 01:38 PM
  6. sorting data (including checkboxes)
    By jeff.nglc in forum Excel General
    Replies: 3
    Last Post: 04-02-2008, 09:22 PM
  7. copy worksheet without including vba code
    By cedtech23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2006, 06:05 AM

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