PDA

View Full Version : Listbox questions



andytpl
08-17-2007, 06:22 PM
I am presently learning about creating userform with listboxes. There are a few questions I hope to find answer for.

1. If the listbox has 2 columns can it be displayed with gridlines?
2. How to create header row and to show the texts for the header.
3. Is it possible to text wrap in the listbox


Appreciate any insight to these questions

Bob Phillips
08-18-2007, 02:49 AM
1 Don't think so, not with a Listbox

2 You have to bind the Listbox to workbook cells with hedaers in those cells, set the columnheaders property to true, but don't include the headers in the bound range

3 Don't think so