UserForm ListBox name can not be changed, why?

[Jamualson]

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

 

[diddi]

try this thread. it uses an activeX listbox which has better flexibility

Trouble using VBA to create ActiveX ListBox on a Worksheet

Apologies in advance for what will be a long post, but I've tried a lot of things and I want to be as clear as possible in explaining my problem to maximize the likelihood that someone can help. To sum up my problem, I can place an ActiveX control on my worksheet, but I cannot seem to edit...

www.mrexcel.com