I need the VBA message box should open and close automatically while macro is running

**Prabakaran3003** · 06-08-2017, 06:35 AM

I am using the below code to receive the output from DB. The code will take the data from DB and keep in Excel sheet.
I need the VBA message box should open and close automatically while macro is running.Please help me to solve this.

Please Login or Register  to view this content.

**6StringJazzer** · 06-08-2017, 09:50 AM

What do you mean by "while the macro is running"? What information do you want to display in the message box? At what point(s) in execution do you want it to appear?

**Prabakaran3003** · 06-08-2017, 10:07 AM

Hi,

While code is running (means while copying the data from DB to Excel) during that period just want to display a msg box which shows "processing !! please wait"
kind of thing. it would be good if it is open and close repeatedly.

**6StringJazzer** · 06-08-2017, 10:14 AM

You can't use a MsgBox so you have to:

Create a UserForm and format it for how you want it to look (let's say it's called UserFormNotify)
Set the ShowModal property to False
In your code, just before each database transaction, add

Please Login or Register  to view this content.

then after the transaction

Please Login or Register  to view this content.

**Prabakaran3003** · 06-08-2017, 10:32 AM

HI ,

I am getting an error "cant show non modal form when modal form is displayed".

**6StringJazzer** · 06-08-2017, 11:30 AM

The sub you showed is called PIN_Click(). Is this for a button on a userform?

Another way to do it is to show a message on the existing form, rather than bring up a new form.

Because of the interaction among forms it would be easier to help if you attach your file.

**Prabakaran3003** · 06-08-2017, 11:35 AM

Hi.. that is a button and not a userform.
I can't attach the attachment since you can't see the results from your system.. how to show the message from existing form.. am expecting the message box to be appear in every 2 secs gap...

**Prabakaran3003** · 06-08-2017, 02:03 PM

Anyone.. please help on this...

**Arkadi** · 06-08-2017, 02:06 PM

Can you provide a sample workbook to look at?

**Prabakaran3003** · 06-08-2017, 02:12 PM

Hi Arkadi...

I have attached the sheet here. i have given the database strings over there... you can only see the code..

Code is available from Userform Called PIN. please help me to solve that.

**Winon** · 06-12-2017, 02:28 AM

Hello Prabakaran3003,

You also need to upload the "C:\Test data.xlsx" Workbook.

Regards.

**Prabakaran3003** · 06-12-2017, 02:44 AM

Hi,

I have uploaded the required workbook. Thanks!!

Regards,
Praba

**Arkadi** · 06-12-2017, 08:36 AM

I should add that:

Please Login or Register  to view this content.

Essentially opens the recordset twice.. you don't need the

Please Login or Register  to view this content.

since you earlier in the code set the rs object, and have opened it with rs.Open....

**Arkadi** · 06-12-2017, 08:46 AM

Ok, try making a form called UserNotify, with the message you want displayed, and give this a go.

Please Login or Register  to view this content.

**Prabakaran3003** · 06-12-2017, 09:03 AM

Hi.. I just tried with this... It is showing cant show non modal form when modal form is displayed.

**Arkadi** · 06-12-2017, 09:10 AM

Are you sure you used the code I posted? I know someone suggested something like this and you tried that version, but mine hides the modal form first and it seemed to work on my end?

**Prabakaran3003** · 06-12-2017, 10:02 AM

Now am getting below error too

**6StringJazzer** · 06-12-2017, 11:32 AM

In the UserForm Editor, you need to change the ShowModal property of your original form as False (modeless).

**Prabakaran3003** · 06-12-2017, 01:44 PM

Hey arkadi, yeah i tried code given by you... it was not working.. i dint change anything on that..

**Prabakaran3003** · 06-12-2017, 01:45 PM

Hey 6StringJazze,

Are you saying solution for this one "SQL0420N Invalid character found in a character string argument of the function "DECFLOAT""??

**6StringJazzer** · 06-12-2017, 09:17 PM

My response was that you were getting an error that you could not display a modeless form when a modal form is displayed. However, I responded before I saw post #16, which seems to answer it.

**Winon** · 06-12-2017, 11:54 PM

Hello Prabakaran3003,

I do not have Excel 2013, and cannot Test the attached sample. Please see if you can make do with it.

Regards.

**Prabakaran3003** · 06-13-2017, 02:03 PM

Thank you wilson. since i am not able to verify it because of getting an another issue.surely i come back to you once i tested your code.

I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Re: I need the VBA message box should open and close automatically while macro is running

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Issue with Open, copy, close Macro - when trying to close workbook Clipboard error

[SOLVED] Automatically open, close & saved documents

[SOLVED] Automatically open and close spreadsheets on Google drive

[SOLVED] Open file --> have pop up message appear --> click on pop up to close it

Bookmarks

Bookmarks

Posting Permissions