-
set the column heading
' Build the column header string with appropriate column names
strColHeader = ""
strColHeader = strColHeader & "Quote Date" & vbTab & "Quote ID" & vbTab
strColHeader = strColHeader & "Created By" & vbTab & "Customer"
' Write the string to the grid
.AddItem strColHeader, 0
' Here you can create all your data rows but
' you must create at least one more row before you can set
' your column header row(s) in the next step
' Tell the grid that you want one row to be your column header row
' Apparently it will choose the first row that you created above
.FixedRows = 1
-
Thanks,
I will give it a try
-
FormatString Property Example
The following examples illustrate how the FormatString property works.
Note If you are using the MSFlexGrid, substitute "MSHFlexGrid1" with "MSFlexGrid1."
' Set column headers.
s$ = "<Region |<Product |<Employee |>Sales "
MSHFlexGrid1.FormatString = s$
' Set row headers (note semicolon at start)
s$ = ";Name|Address|Telephone|Social Security#"
MSHFlexGrid1.FormatString = s$
' Set column and row headers.
s$ = "|Name|Address|Telephone|Social Security#"
s$ = s$ + ";|Robert|Jimmy|Bonzo|John Paul"
MSHFlexGrid.FormatString = s$
Regards,
TheBao