- Joined
- Jul 6, 2005
- Messages
- 7,235
- Likes received
- 209
- Thanks received
- 41
- Location
- whereever the work is
Hi folks,
I have a listbox in a form in excel which I have populated with data. I want to get this into alphabetical order. I have been trying to pass the contents of the listbox to a routine which carries out a bubble sort. Unfortunately it complains with an error saying 'object required'
my listbox is called lstAll
the routine it is going to is called
sortListBox(olb as MSForms.listbox)
What sytax should I use to get it to work? Is there something blindingly obvious I'm missing?
I have a listbox in a form in excel which I have populated with data. I want to get this into alphabetical order. I have been trying to pass the contents of the listbox to a routine which carries out a bubble sort. Unfortunately it complains with an error saying 'object required'
my listbox is called lstAll
the routine it is going to is called
sortListBox(olb as MSForms.listbox)
What sytax should I use to get it to work? Is there something blindingly obvious I'm missing?
