Question

Excel Macro Pop up Issue

  • 18 December 2023
  • 2 replies
  • 128 views
A
Badge +5

Hi Guys,

 

I am executing a macro using the “Run Macro” command in the Excel Advanced package & facing an issue where the macro is getting executed without any issues but at the end a dialog box comes up which indicates that the macro was successfully executed. It is due to the MsgBox command present at the end of the macro code. 

When the pop up comes up, it does not closes automatically as well as the subsequent lines of code do not get executed in AA & the the code is stuck at “Run Macro” command till someone manually click on the OK button of the dialog box.

 

Can anyone please help me to overcome this issue?

2 replies

Abhay Naik
Userlevel 3
Badge +7

Hi @Abhi25 , 

The best solution for you here is to remove the MsgBox action from the Macro code. Else you can try wait and recorder to wait for the window to pop up and then click on the button present in the MsgBox to remove it.

 

Hope this helps!

Abhay Naik
HemanthaPindra
Userlevel 1
Badge +3

Hi @Abhi25,

 

I know it's quiet late reply, may be useful to someone.

 

You have to use Application.DisplayAlerts property. Setting it to False it will prevent Excel from displaying most dialog boxes and alerts.

 

Application.DisplayAlerts = False

' Your code here

Application.DisplayAlerts = True ' Reset back to default

 

Regards,

Hemantha Pindra

 

Hemantha - RPA Developer/Consultant. Contact me over LinkedIn (https://www.linkedin.com/in/hemantha-pindra-5a4041216/)

Reply


Terms & ConditionsCookie settings