asked on
ASKER
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
TRUSTED BY
One of the odd things I notice is that you are setting the TEXT of the top row, then setting the DataType to Boolean. As a guess, try changing the order. Set the Format 1st, then mark the 1st row as Fixed ( .FixedRows = 1), and THEN set the Text with .TextMatrix.
If that doesn't work, then for test purposes, leave out the TextMatrix command all together. If that does work, then try to find some property that flags a row as a "title" row so that the DataType property doesn't apply to it.