dlh
08-30-2008, 03:01 PM
Is there a way to autosize the width of a column in a multi-column listbox based on the width of its entry?
Also is there a *simple* way to automatically expand or shrink a listbox vertically (and the userform which contains it, too) based on the number of rows? Something that doesn't involve calculating sizes and positions of everything based on font dimensions. Can one specify a maximum size so that it doesn't grow larger than the screen?
Is there a way to use multiple fonts in a listbox? For example, could one use a different font for each column (or even within a single column)?
My naive guess is that the answers to each of these questions is "no." I'd appreciate any information either way. Thank you for reading.
Also is there a *simple* way to automatically expand or shrink a listbox vertically (and the userform which contains it, too) based on the number of rows? Something that doesn't involve calculating sizes and positions of everything based on font dimensions. Can one specify a maximum size so that it doesn't grow larger than the screen?
Is there a way to use multiple fonts in a listbox? For example, could one use a different font for each column (or even within a single column)?
My naive guess is that the answers to each of these questions is "no." I'd appreciate any information either way. Thank you for reading.