View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default ListBox ColumnHeads

Use row 3 and below as your rowsource/listfill range for the listbox. Then
the column headings will be filled from row 2.

--
Regards,
Tom Ogilvy


"Soniya" wrote in message
...
Hi all,

I have a list box used to list data based on certain
creiteria.

My data headings are on Row 2. When the data lists in the
list box headings are blank. How can I set row two as
column heads?

TIA
Soniya