ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListBox ColumnHeads (https://www.excelbanter.com/excel-programming/278942-listbox-columnheads.html)

Soniya

ListBox ColumnHeads
 
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

Tom Ogilvy

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





All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com