Listbox still "listens" to its original default name even after renaming, why? After renaming I can not only manipulate it with the new name, but with the original too. I would expect that only new name works.
Thank you very much for your idea.
Sub t()
Dim list As ListBox
Set list = Worksheets("Sheet1").ListBoxes("Default name 12")
list.Name = "New" 'even after this, it still listens to original name, maybe some kind of code name?
End Sub
Thank you very much for your idea.
Sub t()
Dim list As ListBox
Set list = Worksheets("Sheet1").ListBoxes("Default name 12")
list.Name = "New" 'even after this, it still listens to original name, maybe some kind of code name?
End Sub