OK, Please somone help, I'm getting very frustrated!!
I don't know what is going on, I've tried to use the code just as it is shown above but everytime I try to run this and other combinations of the listbox.rowsource code it errors and says "object required".
Any thoughts or ideas.
Here is the code exactly as I'm trying it.
Private Sub ListBox2_Click()
ListBox2.RowSource = "a1:a10"