Vba - Msflexgrid

' Write "Hello World" to Row 1, Column 1 MSFlexGrid1.TextMatrix(1, 1) = "Hello World"

' Auto-size columns (basic) fgProducts.ColWidth(0) = 500 fgProducts.ColWidth(1) = 2000 fgProducts.ColWidth(2) = 1500 fgProducts.ColWidth(3) = 800 msflexgrid vba

' Define fixed rows (headers) and fixed columns (labels) fgProducts.FixedRows = 1 fgProducts.FixedCols = 1 ' Write "Hello World" to Row 1, Column 1 MSFlexGrid1

There are three primary ways to fill an MSFlexGrid. Column 1 MSFlexGrid1.TextMatrix(1

' Avoid header row If selectedRow > 0 Then MsgBox "Selected: " & .TextMatrix(selectedRow, 1) & vbCrLf & _ "Salary: " & .TextMatrix(selectedRow, 3) End If End With