It takes about 20 seconds to populate the list box with 1100 names if I do it one at a time in a loop. Is there a quicker way to do it? Since the list box has to be set up every time the file is opened, this is pretty tedious.
I still have not found out why the ListBox1_Click routine is running after every key stroke. Can I set it up to run when I click on a name?