Three Dimensional Data Array Grid and Report Viewer

Forms and Controls

Version Compatibility: Visual Basic 6

More information:

The module shows how to use a three deminsional array to store, read and display column widths, row heights and data. For the sake of simplicity, I loaded static data of fixed rows and heights in the form load event, but a user interface could be created to dynamically store varying widths and heights.

I included a procedure for determining which corresponding cell the mouse is over and displaying the data from that cell in the form caption. This is a dynamic procedure that will adjust to varying cell widths and heights.

Again, the GetRowCol procedure is encapsulated and easily portable to a project or bas file. Included is a report viewer, save capability and print preview .

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.