Dim fg As MSFlexGridLib.MSFlexGrid Set fg = Me.Controls.Add("MSFlexGridLib.MSFlexGrid", "fg") Once you have added the MSFlexGrid control to your project, you can customize its properties and methods to suit your needs. Here is an example of how to populate the MSFlexGrid control with data:

Working with MSFlexGrid in VBA: A Comprehensive Guide**

fg.Rows = 10 fg.Cols = 5 For i = 0 To 9 For j = 0 To 4 fg.TextMatrix(i, j) = "Cell " & i & "," & j Next j Next i