Quote Originally Posted by hightime
Interestingly, with this method there seems to be a pause between clicking on a dropdown and waiting for it to actually drop. It must be the time taken for the code to store the data and then read again. It was instantaneous before.
No complaints though, it only offers exclusive data as I asked.
Paul,

I tried your code on my machine (XL2002 on Win2K; 2 GHz, with 680 MB RAM). The dropdown was nearly instantaneous.

Perhaps adding RAM might be a solution. Just thought you might be interested.