Hello,
I have created a userform with a listbox and a textbox. The listbox lists the names of all the ListObjects on the active worksheet. When one is selected, the listObject's contents are displayed in the textbox for editing. I need to be able to copy single columns of numbers from other workbooks and paste them into the textbox in my userform. This is difficult, as all other workbooks are locked out when the userform is displayed, and even if I copy the cells before displaying the userform, the cells seem to get dropped from the clipboard before I can hit the "paste" button that I added to the form. Any ideas?

Thanks,
Jarrod