Why is this VBA code (that I wrote) executing so slow?

Alan,

My apologies for the mistake. Is the moderation request fulfilled correctly?

Can you submit your workbook? I am a little curious about the interaction of cboDept1_Change() and the UserForm_Initialize processes and how they may be affecting each other. Also, this is beyond reason:

Please Login or Register  to view this content.

stnkynts,

Thanks for your reply. See attached my workbook (in zip file).

The Workbook is 'Menu driven' and will only show the sheets you've opened. To see all the sheets in the workbook, from the Main Menu click on the Administration button, use Admin as user name and the letter a (small caps) as the password. Then click on "Show All Sheets" button in the upper right.
The password to un-protect any or all sheets is the letter j (small caps).

I'm no expert in Excel, and am trying to learn VBA as I go, so I'm sure you'll find some illogical processes in the workbook.

Thank you for your willingness to take a look.

John

Please remove from zip file and attach directly.

Please advise me how to. The file is too large (4.5 MB) to be accepted as an attachment.

I've been asked to show my workbook, which I'm glad to do, but the forum doesn't allow any workbook larger than 1K to be shared as an attachment. When I send the Workbook in a zip file, I'm being asked to please unzip and send it as a workbook. I'm confused. Please advise what I should do.
This site has been a great learning experience and I really, really would like some feedback on the issues I'm trying to solve in my workbook.

Thank you,

John

Thank you for your reply Leith. I was starting to wonder what I was doing wrong.
I guess if no-one else replies to my post/question, my question must not be enticing enough.
It's a challenge to find a VBA expert who can look at my code and explain to me why my code is slowing things down (because I suspect I wrote it very poorly).
I'll post my message/question again.

Regards,

John