Macro doing activities twice.

[deepak.sirsale]

Hello Everyone,

I have buid a code to pull counts from other files and it takes some time. While to do this i want to show User form and i have added it in my code and it is displaying it. But the problem is Macro is doing the activities twice. and i not getting where i am worng. Please help...
PFA for the same Sample.xls

Please Login or Register  to view this content.

[ragulduy]

Your sample has a password on the vba project.

[:) Sixthsense :)]

Please supply the VBA project password

[deepak.sirsale]

Opss Sorry... It's Invincible

[ragulduy]

Please Login or Register  to view this content.

Looking through your code, that is how I would do it. Not sure if it will fix your problem..

[deepak.sirsale]

Hi yudlugar,

Thanks for your help, but the above code is not working fine, It is selecting First file from folder and doing activities..... but not going on next file..
and the macro is not stopping it is contineously selting first file and so on.... and also the form is displaying in white color...

[ragulduy]

Oooops, I forgot an important part!

Please Login or Register  to view this content.

[deepak.sirsale]

Hi yudlugar,

The Code is working fine, Except Userform... it is showing White coloured form.... and when i use Doevents then it it showing the from but same issue as my coding has.... it is running twice.....

[ragulduy]

You have "corefunction" written in your userform_activate event. So when you load the userform it will repeat the code again!

Use do events and delete the userform_activate code from the userform code module.

[deepak.sirsale]

Oh.... !!! Thanks..... Now working perfect...!!