Listbox column header not working

[Uzma Shaheen]

Hi

i have some data that i am populating info from sheet range A1:C50 to listbox howver the first row is the header but i cant seem to get it as the header (i.e A1:C1) is the header
i have also set the column to 3

this is my code to populate the listbox

lst.list = sheets("sheets1").range("a1:c100").value

any help would be really appreciated

thank you

 

[MickG]

To use headers I think you'l find you need to set the range as a "ListFillRange" or "Rowsource".
as below:-

	
	

		
[COLOR="Navy"]Sub[/COLOR] MG24Mar33
[COLOR="Navy"]With[/COLOR] ListBox1
    .ColumnHeads = True
    .ColumnCount = 4
    .ListFillRange = "A1:D12"
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
	
Regards Mick

 

[Uzma Shaheen]

Thank u mick