+ Reply to Thread
Results 1 to 2 of 2

How to dynamically change linked cell for spinbutton control

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    Aberdeen
    MS-Off Ver
    MS365 VER 2308
    Posts
    79

    How to dynamically change linked cell for spinbutton control

    I have a table of numbers with spinbutton controls where the linked cells are in C104:F117.
    Depending on the value of another cell, I need to be able to switch those linked cells to a different range, eg G104:J117.

    I can't seem to use the "indirect" function in the linked cell reference though, as "tried" in the attached image. Is there another way?

    Capture.JPG.

    Any ideas how to achieve this?

  2. #2
    Registered User
    Join Date
    12-10-2008
    Location
    Aberdeen
    MS-Off Ver
    MS365 VER 2308
    Posts
    79

    Re: How to dynamically change linked cell for spinbutton control

    Solved this myself using dynamic named ranges. thanks anyway.

+ 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. Spinbutton Control
    By rbpd5015 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2014, 03:48 PM
  2. Add control dynamically and change the position of the control
    By annpricks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 12:57 AM
  3. Replies: 2
    Last Post: 07-22-2012, 05:10 PM
  4. SpinButton for Images control
    By Aikuchi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2009, 01:28 AM
  5. Spinbutton to control multiple textboxes
    By Khaos176 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2009, 01:35 PM
  6. [SOLVED] SpinButton control loops infinitly when calling a ATL COM server
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 02:06 PM
  7. Replies: 0
    Last Post: 03-16-2005, 02:06 PM

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