VSC

.

overview

This is a full-featured grid ActiveX Control, including ADO support, Outlook-style grouping, attach bitmap to cells, built-in cell modes, built-in splitter, etc.
SCGrid is freeware
 

features:

 
  • Supports ADO (browse only)
  • Fixed cells are numbered negative so non-fixed cells always start with 0.
  • Cell’s built-in CommandButton, CheckBox, ComboDropDrownList, TextBox.
  • Background bitmap.
  • Rows, columns resizable.
  • Splits columns.
  • Uses mask-color.
  • etc...

New properties are added to individual cell :

  • ColSpan, RowSpan : groups the specified number of columns, rows.
  • CellStyle : changes the 3D style of the individual cell (Flat, Inset, Raised, Button-Style).
  • CellMode  : changes the behavior of the individual cell when entered.
  • ColLineColor, RowLineColor : draws right-line, bottom-line with the appropriate color.
  • Key : this is like Tag Property, but attached to an individual cell.
  • etc...

New events that could be useful, so you don’t need to write complicated codes :

  • CellOver : returns the cell beneath the mouse (CellOut : when mouse quit the cell).
  • ScrollTrackRow/ScrollTrackCol : when the user drag the button scroll-bar, it returns the value corresponding to the column/row of the grid in relation to the position button.
  • etc...

.

 
download
 
· SCGrid.ocx version 4.4 (103 KB) ·
for windows 9x/NT/2000
· with Help & Demonstration (236 KB) ·
· for VB5 (97 KB) ·

.


recent versions
 

· 4.4 ·

  • fixed bugs

· 4.3 ·

  • uses custom control (event beforecustom, property customhwnd)
  • doesn't need mscomct2 because datepicker is no more implemented
  • adds property colOrder
  • adds new methods (getcellatpos, getpositioncell,
  • getsizecell, getpicturecell, getpicturegrid, exitedit, gridlinewidth)

· 4.2 ·

  • adds new methods (textmarginleft, textmarginright, move)
  • retrieve selections by using for i=1 to ... instead of for each x in ...
  • fixed bugs

· 4.1 ·

  • adds new methods (adjustsizerow, adjustsizecol, autosizerows)
  • changes sort parameters (sorttype, sortorder, sortusekey become properties)
  • fixed bugs

· 4.0 ·

  • supports ADO (browse only)
  • adds new methods (show, hide, insert, copy, delete)
  • selects rows/columns
  • sorts rows
  • fixed bugs

· 3.0 ·

  • resizes rows, columns
  • splits columns
  • uses mask-color
  • width columns in percentage
  • fixed bugs

· 2.1 ·

  • displays background bitmap with different modes
  • enhanced the use of arrow keys
  • fixed bugs

· 2.0 ·

  • displays faster
  • adds new event (cellout, textchange) and methods (rowclear, colclear)
  • uses arrow keys to move in the grid
  • can be use with VBA (problem at design time, but works at runtime)
  • fixed lots of bugs

.