+ Reply to Thread
Results 1 to 1 of 1

Copy and paste combo box with relative Cell Link (Form Controls)

  1. #1
    Registered User
    Join Date
    04-26-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    14

    Post Copy and paste combo box with relative Cell Link (Form Controls)

    Hi!

    Is there a way to copy and paste combo box form controls keeping the input range static but the cell link relative in Excel 2013?

    I've tried usual methods, but all seem to paste a combo box with absolute ranges and cell links.
    I have to create many combo Boxes then have copy them with relative cells links.

    Link to a similar solved thread (it used Active X controls instead of form control) is given.

    https://www.excelforum.com/excel-for...cell-link.html

    I'm not a VBA user/ programmer and hence cant modify the solution in the above link to my specific requirement. Sample scenario is enclosed in a simplified manner.

    Any help will be appreciated.
    Attached Files Attached Files
    Last edited by vpipalia; 04-28-2017 at 04:40 AM. Reason: Form Controls, VBA, Combo Box

+ 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 and paste combo box with relative Cell Link
    By waheed254 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 04-27-2017, 10:25 AM
  2. [SOLVED] Combo box border from form controls
    By wrybel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2017, 08:32 AM
  3. Replies: 0
    Last Post: 08-15-2015, 10:42 AM
  4. Replies: 2
    Last Post: 12-04-2013, 11:49 AM
  5. Create mutiple combo box form controls using Macro
    By booo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2010, 07:51 PM
  6. Replies: 0
    Last Post: 07-09-2010, 12:54 PM
  7. [SOLVED] Can I copy a combo box in Excel 2002 with a relative cell link?
    By Bozo in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 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