petroj02
11-10-2016, 04:00 AM
Hello all,
I hope there is someone who can give me an advice. With this code It gives me back an error mesage: Unspecified erorr. I have found at different thread, that it is because of using rowSource property. Is here other way how can I define data source then with rowsource property?
There is the thread I have found. http://www.mrexcel.com/forum/excel-questions/912540-removing-item-listbox-error.html
(http://www.mrexcel.com/forum/excel-questions/912540-removing-item-listbox-error.html)
there is code with Erorr
For i = ListBox1.ListCount - 1 To 0 Step -1
If ListBox1.List(i) <> "Something" Then
ListBox1.RemoveItem i
End If
next
and there is a code with Definition of data source
LastAddress = ThisWorkbook.Sheets("LED_IM").Range("AM65536").End(xlUp).Address
newACC.Controls("Listbox1").RowSource = "LED_IM!AK3:" & LastAddress
Thank you for your help
I hope there is someone who can give me an advice. With this code It gives me back an error mesage: Unspecified erorr. I have found at different thread, that it is because of using rowSource property. Is here other way how can I define data source then with rowsource property?
There is the thread I have found. http://www.mrexcel.com/forum/excel-questions/912540-removing-item-listbox-error.html
(http://www.mrexcel.com/forum/excel-questions/912540-removing-item-listbox-error.html)
there is code with Erorr
For i = ListBox1.ListCount - 1 To 0 Step -1
If ListBox1.List(i) <> "Something" Then
ListBox1.RemoveItem i
End If
next
and there is a code with Definition of data source
LastAddress = ThisWorkbook.Sheets("LED_IM").Range("AM65536").End(xlUp).Address
newACC.Controls("Listbox1").RowSource = "LED_IM!AK3:" & LastAddress
Thank you for your help