Worksheet_Calculation triggered by drop down box

[thecrue2]

Hi,
I am having issues with getting some code to work. I am very new to this so I could be making stupid mistakes and I'm hoping there's an easy solution!
What I am trying to do is trigger an event when a cell changes, and this cell is updated via a linked drop-down box.
The issue is that the code seems to work fine (in about 10 seconds or less) if a manual calculation is entered into the sheet - but when it's done via the drop-down box, it takes about 3 minutes to complete the macro.

To trigger the event, I am using:

Please Login or Register  to view this content.

So basically, when the drop down box is changed, it links to MENUS!D34 and then the appropriate SHEETS are found and copied into COPY sheets. As mentioned, this code runs perfectly fine (and fast!) if I MANUALLY type a calculation into the MENUS tab, but once it uses the drop down box it runs extremely slowly.

Any suggestions? Apologies if it's a long-winded question!!

Any help appreciated!!

[Leith Ross]

Hello thecrue2,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.
3. To do it manually...
Use the Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


To learn more about BB codes used in this forum, just click on the link below...

Bulletin Board Codes Tags

[thecrue2]

Hi,
I have solved this issue - the problem was not with the fact that the code was being triggered by a drop-down box, as I first thought - it was taking so long because I was not bypassing the clipboard when copying my data.
Seems to work fine now.