Rename an Item In Listbox

[yinkajewole]

How can i rename an item in a listbox that is already loaded on a userform with a textbox value?

 

[NdNoviceHlp]

You can't rename it but you can clear the listbox and then reload it with the new adjusted list. Perhaps on some textbox entry event? Dave

 

[yinkajewole]

You can't rename it but you can clear the listbox and then reload it with the new adjusted list. Perhaps on some textbox entry event? Dave

really? is also it possible delete a listbox value with a command button?

 

[NdNoviceHlp]

U can remove listbox items....

'remove last item in listbox
If UserForm1.ListBox1.ListCount <> 0 Then
UserForm1.ListBox1.RemoveItem (UserForm1.ListBox1.ListCount - 1)
End If

I've always just cleared the list, adjusted it's source values with the changes and then reloaded it...

'clear and reload listbox
UserForm1.ListBox1.ListIndex = -1
UserForm1.ListBox1.Clear
For cnt = 1 To [Sheet1!A1]
UserForm1.ListBox1.AddItem Sheets("Sheet1").Range("B" & cnt).Value
End If
Next cnt

If U adjust your list of items in "B" in the above example and if A1 represented the number of items, U can then reload the listbox with whatever. U can do this by any macro, event and/or command button. HTH. Dave