+ Reply to Thread
Results 1 to 2 of 2

Scroll 2 listviews at the same time, Excel VBA, help please

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Surabaya, Indonesia
    MS-Off Ver
    2010
    Posts
    80

    Scroll 2 listviews at the same time, Excel VBA, help please

    Hi all,

    linkback http://www.mrexcel.com/forum/excel-q...ml#post4530642


    I have this problem, I have 2 listview in 1 userform in excel, I can't combine the listview list, but both listviews is correlated. so I need to fine a way, to scroll them at the same time, how to do that?
    and I'm attaching my file too

    Capture.JPG

    please help if this is possible,
    thanks a lot
    warm regards


    Adrian
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Scroll 2 listviews at the same time, Excel VBA, help please

    Previous reply deleted - I assumed/read as Listboxes, not ListViews.

    Not quite as simple as with Listboxes, which have a TopIndex property - you simply set the Topindex to be the same as the Topindex of the listbox in focus.

    The simplest way to do this is to use the GetFirstVisible property of the ListView and Use the Ensurevisible property to ensure that item is visible in the second.

    Please Login or Register  to view this content.
    There should also be a corresponding event for ListViewAsing.

    The disadvantage is that the items may not be in the same 'vertical' position and this is difficult to see as you never mentioned anything about selecting the matching item.
    Last edited by cytop; 05-24-2016 at 06:46 AM.

+ 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: 05-17-2016, 04:45 PM
  2. Replies: 2
    Last Post: 09-03-2015, 10:33 AM
  3. Replies: 14
    Last Post: 11-28-2014, 02:12 PM
  4. Excel 2013 : Slicers don't scroll when i scroll the sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2014, 10:23 AM
  5. Scroll Multiple Rows/Columns at a Time
    By rowish in forum Excel General
    Replies: 3
    Last Post: 03-18-2013, 05:05 PM
  6. Sheet Scroll to the Right on time change
    By peakymatt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-02-2010, 12:50 AM
  7. scroll less than one row at a time
    By Jacob_Jacob in forum Excel General
    Replies: 0
    Last Post: 03-05-2009, 02:20 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