+ Reply to Thread
Results 1 to 1 of 1

Scrollbar - Editable area

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Cz
    MS-Off Ver
    Excel 2013
    Posts
    13

    Unhappy Scrollbar - Editable area

    Hello,
    I have attached a simple excel.

    I have two scrollbars there - ScrollBar1 and Scrollbar2
    ScrollBar1 allows me to scroll left part of the table. The table is also editable - whatever I change changes even on the other List.

    Scrollbar2 allows me to move the right side of the table horizontally.

    1) I would like to extend functionality of ScrollBar1 to the other part of the table = it would scroll the columns on the left of it and even on the right side. Currently it only scrolls on the left of it.
    2) Is it possible to have the Scrollbar2 work as is, except not using OFFSET, but rather VBA as the first one, allowing for edditing of the cells?

    Basically what I am trying to achieve is having one table, where Scrollbar in the middle of it scrolls both areas Up and Down and second Scrollbar scrolls the right side of the table Left and Right, WHILE allowing for editing of the cells.

    Thank you for some ideas
    Attached Files Attached Files

+ 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: 2
    Last Post: 11-02-2015, 07:57 PM
  2. Replies: 2
    Last Post: 03-25-2015, 07:13 AM
  3. Pivot Tables-Filtering in Page area (Report Filter Area)
    By Andrea Fuschetto in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-03-2015, 03:37 PM
  4. [SOLVED] Using a scrollbar button to select and insert a text in cell from an input area.
    By gnaske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2014, 02:28 PM
  5. Change ScrollBar Max value when a second ScrollBar vale is changed?
    By Jon Henry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 06:47 PM
  6. Replies: 0
    Last Post: 02-28-2012, 09:47 AM
  7. [SOLVED] scrollbar reslut makes another scrollbar to show
    By Patrik in forum Excel General
    Replies: 0
    Last Post: 04-18-2005, 11:06 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