Subscribe
in a reader
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...