This is my first time posting on this site and I am a beginner VB programmer. I have been able to solve many of my previous questions through existing threads but have not found what I need to solve this problem. My problem is that I have a listbox on my main sheet that I can successfully import data to but am having trouble retrieving the selected items and using them in further calculations. Where I am having the biggest problem now is in the following piece of code:
ActiveSheet.Shapes("Set_Listbox").Select Dim lItem As Long Dim Count As Integer Set Count = Set_Listbox.ListCount (Problem here!!!) For lItem = 0 To Count - 1 If ListBox1.Selected(lItem) = True Then Sheets("Main").Range("A65536").End(xlUp)(25, 7) = ActiveSheet.Shapes("Set_Listbox").List(lItem) ActiveSheet.Shapes("Set_Listbox").Selected(lItem) = False End If Next lItem
I am getting the error that an object is required and after over 4 hours of trying to look for existing threads on the subject, I have not found much help. Any help will be greatly appreciated.
Thanks a lot,