EXCEL VBA 360 , Listview items , new on top

[nmk34]

show new added items in Listview on top and not added to the bottom as the default. I thinks i tried Listview.items.insert(0,"new item") not valid in excel 360 VBA

 

[Domenic]

The indexing for a ListView control starts at 1, and you should using the Add method of the ListItems object. Therefore, try . . .

ListView1.ListItems.Add Index:=1, Text:="new item"

Or, without named arguments . . .

ListView1.ListItems.Add 1, , "new item"

Hope this helps!

 

[nmk34]

even though i am not getting an error, but no data being added and the listview scrolls down when i run the above code

 

[nmk34]

even though i am not getting an error, but no data being added and the listview scrolls down when i run the above code

your code works greate, i forgot to set the object

 

[Domenic]

That's great, glad I could help.

Cheers!