I'm using Excel 2016 and I would like to add a grid or grid-like control in a userform. In my userform's toolbox, additional controls, I don't see MSHFlexgrid or MSFlexgrid or anything that I recognize as a grid control. What can I do?
Printable View
I'm using Excel 2016 and I would like to add a grid or grid-like control in a userform. In my userform's toolbox, additional controls, I don't see MSHFlexgrid or MSFlexgrid or anything that I recognize as a grid control. What can I do?
I realize now that I can create a "grid" out of an array of textboxes. Is there any built-in control I can use?
There are ways to do this. Possibly useful links:
https://stackoverflow.com/questions/...ed-on-userform
http://www.vb-helper.com/howto_vba_editable_grid.html
https://10tec.com/articles/excel-vba-grid-control.aspx
https://social.msdn.microsoft.com/Fo...l?forum=isvvba
However, if I need a grid in Excel, I like to keep it simple. Since I am using Excel, I just create a sheet tab that has what I need. No need to re-invent the wheel (or grid).
"However, if I need a grid in Excel, I like to keep it simple. Since I am using Excel, I just create a sheet tab that has what I need. No need to re-invent the wheel (or grid)."
I never thought of that! Thanks.