LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Column heads for list box - how to do it

Different colors. No.

You can set the columnheads and columncount property in the properties of
the listbox - no code needed.

You have to use the rowsource (userform) or listfillrange (worksheet)
property of the listbox to populate it if you want to use column heads. If
you set columnheads to true, then the data in the row above your
rowsource/listfillrange is used to populate the column heads (so don't
include your header row in the rowsource or listfillrange address).

--
Regards,
Tom Ogilvy

"Oliver Kharraz" wrote in message
...
Hi,

does anyone have sample code that

a) uses a ListBox with several columns
b) Adds items to this listbox?

Ideally, I would even like to have the different lines to have different
font colors - is this possible at all in VBA?

Thanks so much for your help,

Oliver






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Column Heads WITHOUT Excel Column Lables Sarah E Excel Worksheet Functions 1 June 19th 08 07:06 PM
Changing column heads from ABC to 123 Sanjeev Raghavan[_2_] Excel Discussion (Misc queries) 2 June 4th 08 06:02 AM
List Tabs and Column Heads Hugh Murfitt Excel Discussion (Misc queries) 1 July 4th 07 09:02 AM
Column heads are numbers [email protected] Excel Discussion (Misc queries) 4 April 10th 06 09:20 PM
column heads 4most New Users to Excel 5 April 25th 05 05:52 PM


All times are GMT +1. The time now is 12:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"