Sjvenz wrote:
I get the error when I close down the form, but nothing is
highlighted.

Does the error not come with a Debug button to take you to the
offending line of code?

I don't fully understand the code you posted; it doesn't seem to
correspond to your description of what you are trying to do.
There are 2 UserForm_Initialize routines for a start.
In the first one you seem to be adding the same information to ListBox1
and ListBox2.

ListBox1 is, I assume, single select.
So the first loop in ListBox1_Change is not needed. You can just use
ListBox1.ListIndex in place of RowSelected.

I suggest you use the debugging facilities to step through your code
and see where it is not doing what you want.



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup