I have a problem with an Excel VBA Sub. The sub takes a range of data
from a worksheet, and retrieves corresponding data from an Access
database, then displays the data on the worksheet.

The user types an number into the cell, and all of the corresponding
data is populated on the worksheet. There is never any problem if I
type, and press enter. But if I try to paste a number into the cell,
Excel appears to lock up ... I can't select another cell, and none of
my data is returned. As soon as I click the Red X to close the window,
I get the Dialog box asking if I want to save changes to the sheet, and
I click Cancel. Immediately all of the data is displayed perfectly, and
it appears that the sub has finished, and everything is working
perfectly again.

Wondering if anyone has any ideas out there? I've been trying to debug
for two days, and have thought about removing the ability of a user to
Paste, but it will be important for them to be able to paste a list of
item numbers into my app.

Any help would be greatly appreciated.

Thank you in advance for any advice!
Mark