Printable View
For a multicolumn listbox located in a sheet, how can I specify the name to appear in the column's head?
If it was located in a userform, one could use the .RowSource property, but this property doesn't exist when located in a sheet...
Extra question. Is it possible to change the colour of a single column?
Right click on the listbox and change theQuote:
how can I specify the name to appear in the column's head?
.ColumnHeads = True
.ListFillRange = Sheet1!A1:C4 'say this is the range
Hmmm... not sure about this...Quote:
Extra question. Is it possible to change the colour of a single column?
Hope this helps...
Do you mean like right-clicking the column letter, selecting format cells and going to the patterns tab?Quote:
Originally Posted by Fonty
I mean that the specific column appears in a different colour than plain white.
Oh, duh. This is about listboxes. No, I'm not sure that you can.