MSFlexgrid question please

Posted on 2005-04-26
Last Modified: 2010-05-02
I have a form with 2 MSFlexgrids.
The top grid is simply there for COLUMN TITLES.
The second grid (beneath it has the data rows)
(I HAVE TO HAVE it this way. Don't suggest putting the titles in the lower grid please.)
The top grid has:
NAME                 ADDRESS                 CITY             STATE             ZIP              
for example.

The lower grid does not fit horizontally on the screen so there are scroll bars right to left.
Everything looks good untill I scroll the bottom grid, then of course, the top grid column lables are wrong becuase it does not scroll too.
My question is, can I make it scroll too or follow the scrolling of the bottom grid?

Question by:yyuubum2
    LVL 4

    Accepted Solution

    Well...i won't suggest you to have one flexgrid instead of two if you like to knock your head into the wall so much :-), but obviously you can scroll both flexgrids simultaneously:

    Private Sub Lower_grid_Scroll()
    Upper_grid.LeftCol = Lower_grid.LeftCol
    End Sub


    Author Comment

    Excellent! Exactly!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now