ActiveX

To customize virtual mode

1. Specify the number of rows read into the virtual buffer at a time using the VirtualRows property.
   If the sheet can display more rows at a time than the number of rows specified, the value of the VirtualRows property is reset to the number of rows the sheet can display.
2. Set the VirtualOverlap property to specify the total number of previously retrieved rows that are retained in a buffer.
3. Set the VirtualScrollBuffer property to True to have the vertical scroll box reflect only the number of rows in the virtual buffer rather than the total number of rows.
4. If you set the VirtualScrollBuffer property to False or if the control displays the row headers with numbers, use the VirtualMaxRows property to provide the sheet with the number of rows in the sheet or bound database.
5. If your sheet is not bound to a database, you must indicate the number of rows loaded in the QueryData event. After each data request, set the RowsLoaded parameter to the number of rows that have been loaded.