Speed Up code procedure

[coreytroy]

The below code basically via a form, selects the required data in a sheets row(listbox value), and places the data into a sheet used as a speadsheet.

However, sometimes the code runs almost instantly, yet other times the code runs slowly, and can take 5 seconds to complete.

Please Login or Register  to view this content.

[coreytroy]

I have just tested another workbook, with much more code on a similar vein as this code.

Yet, it runs very quick and smooth when compared to this code.

Would a worksheet_event code (if found) slow code switching between sheets?

[coreytroy]

Just found the problem.

The Worksheet_Change event was slowing the code down.
I had a footer spec, code in there.
If i remove the footer code into the form code all is sped up then.