Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox
Introduction
For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like:
Description | Before | After |
Cell Errors | 100 | 10 |
Corrupt Names | 1000 | 0 |
Unused styles | 232 | 0 |
So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved far from easy...