Tips and tricks

1. Using labels to resize the columns in a listbox.

This code sample was suggested to me by MrIfOnly on the MrExcel forum. It demonstrates a neat way to resize columns in a listbox – currently restricted to redistributing the initial listbox width amongst the columns. File can be found here.