Listbox Column Header as Excel Column header name

[Senthil Murugan]

Good Morning everybody

Could anyone help me to get the answer ( code ) for the following

I need ListBox1 Header as Actual Excel Column header as A, B, C till the used column data in First Row
and
Rowsource is 1st row data

Please see my image attached

with regards


A.Senthil Murugan

 

[Micron]

You can simply set the Column Heads property to True if you don't mind that including the word "Column" as well. See listbox property sheet, Data section.
EDIT - that applies if you've set the rowsource property as beginning with the first row. If not, the header values will be whatever is in the row above the top row of the rowsource. In that case, you should be able to put A, B, C etc. in the first row above the rowsource topmost row.