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...

Read on...

UserForm Setup
How It Works
Module Code and Conclusion

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

Introduction

Contents