10-09-2001, 06:44 PM
Can anyone help with info on this function.
In particular what are the small boxes that seperate the cell content, and what code would I need to use to trap that.
If mshflexgrid.clip = "box" then
10-10-2001, 01:21 AM
This is one way to load data into the Flex Grid. (I refer to the MSFlexGrid control, the MSHFlexGrid is similar)
Basically you set up a string filled with data where the columns are separated by the tab character (Chr$(9) or the constant vbTab) and the rows are separated by the cursor return character (Chr$(13) or vbCR)
When you use this method of loading a flexgrid, you must create the required columns and rows and select them all <font color=red>before</font color=red> setting the .Clip property to your string.
Likewise the cllip property returns a string delimited by tabs and cr's for the selected cells in your flex grid.
A little hint, if you are going to build a string and load it, set the string to a large size first (using Space$ or String$) and then use the Mid$() function (Left hand side) to move through the data and set it rather than using concatenation, which is really slow...
<font color=blue>I once had an itch that I scratched and off fell my leg.</font color=blue>