JKP Application Development Services.

Microsoft Office Application Development

Listbox AutoSize

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize • Fix Links to UDFs

• UserForm Setup • How It Works • Module Code & Conclusion •

Search

Zoeken

Go to	Ga Naar
Home Up UserForm Setup How It Works Module Code & Conclusion

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

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

Content

UserForm Setup
How It Works
Module Code & Conclusion

statistics

Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2008 JKP Application Development Services