Waiting message.

[Prabakaran3003]

Hi, i am just trying to connect DB thru macro and i have done it. the macro will fetch the data from DB and paste into Excel sheet. this code is working fine.
But, while this process going i want to show the please wait pop up message till the end (each 2mins gap). can anyone help on this?

[Winon]

Hello Prabakaran3003,

Best would be to employ a Userform for this.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[cytop]

This is the same issue as posted here and here.

In the first thread linked above the OP was requested to continue in his original thread...

[Prabakaran3003]

attached the sample book. The required code is available from userform called PIN (main code assigned for button from same form). while the code is running just want to display the
please wait message in each 2mins gap.

Regards,
Praba

[Winon]

Hi Prabakaran3003,

Thank you for your reply, however as cytop has pointed out, this is a third duplicate of your original post, and that is against the Forum Rules. Please select which of the duplicates you want to close and mark them as solved with a reference to to the Post where you would like to continue.

Until you have complied with the request above, I am afraid that I feel obliged not to try and help you until you have corrected this matter.

Regards.

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.