+ Reply to Thread
Results 1 to 2 of 2

Need to copy and paste activex buttons while changing the ranges they work with

  1. #1
    Registered User
    Join Date
    07-24-2014
    Location
    Phoenix
    MS-Off Ver
    2007
    Posts
    21

    Need to copy and paste activex buttons while changing the ranges they work with

    Will appreciate any help
    First post so... sorry if there is something wrong below.

    I have a table with Titles from A2:I2
    There is another Table from K2:N26 with Title in row 2
    The way the second table works is to give users two sets of data (columns L and M) and let them decide if they want to use this data to fill column N with simple activex buttons at the top of each data column that would simply copy and paste the selected column. Users can also input whatever data they want.

    Ive created a template of this but now to the problem:
    I need one of these tables (K2:N26) for each of the filled rows in first table mentioned, this first table is filled out with information from a Macro and is variable in length. I would like for created tables to be moving to the right so the first would be (K2:N26) second (P2:S26) and so forth. I know how to copy the cells and fill the tables but is there a way to have each table have their own set of buttons that will only interact with the table below it.

    Using Excel 2007

    Thanks in advance

  2. #2
    Registered User
    Join Date
    07-24-2014
    Location
    Phoenix
    MS-Off Ver
    2007
    Posts
    21

    Re: Need to copy and paste activex buttons while changing the ranges they work with

    Was able to come up with my own answer:
    Please Login or Register  to view this content.
    Modification from post on http://stackoverflow.com/questions/6...clicked-button that links to http://www.ozgrid.com/forum/showthre...317#post167317

+ 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. Copy text from activeX textbox and paste into excel
    By montecarlo2079 in forum Word Formatting & General
    Replies: 29
    Last Post: 07-25-2013, 03:48 PM
  2. Excel 2007 ActiveX Combobox - LinkedCell automatically change w/ copy/paste
    By jdgonzal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 05:46 PM
  3. [SOLVED] Copy & Paste Macro Buttons
    By The Skipper in forum Excel General
    Replies: 6
    Last Post: 12-24-2012, 07:28 PM
  4. Copy/paste buttons to same position
    By Hambone70 in forum Excel General
    Replies: 2
    Last Post: 02-13-2011, 12:00 PM
  5. Copy and Paste to Worksheet using Combobox (ActiveX)
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-23-2009, 09:23 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