vba if message box pop up then

[Pinaceous]

Hi All,

Is there a vba code that can be created to respond to a message box pop up?

I need help on starting this code, for example, if a message box pops up then

'do something.

Please let me know.

Thank you!
Pinaceous

 

[PeteWright]

A message box is nothing you can respond to. It's just in between.

You could run some code where you check if a condition is met, then respond with a message box and after it was closed run some other code.

May I ask, what exactly are you planning to do?

 

[Joe4]

Yeah, I am also a bit confused by the question, not really understanding what they want to do.
I agree that it would be good if they could clarify it and tell us exactly what it is that they are trying to do.

Note that in VBA code, you can see HOW a user responds to a MsgBox (if they click "Yes" or "No"), and do some action based on that.
But if you are looking for user input, it is better to use an InputBox, i.e. InputBox Function in Excel VBA

 

[Pinaceous]

Hi Guys!

I'm working with an Excel file, which is providing a message box upon its opening but it remains in the background behind the Excel document and does not come forward, which is causing a lot of confusion to say the least!

Thanks,
Pinaceous

 

[Joe4]

What kind of message box is it?
What does it say?
Is it being generated by VBA code?
If so, please post that code for us.

 

[Pinaceous]

What kind of message box is it?
What does it say?
Is it being generated by VBA code?
If so, please post that code for us.

This is what the message box says above.

It is not being generated by VBA code and I am trying to either bring this message box forward or to do something like minimize the document, so the user can act on this pop-up.

I need help with bringing this message box forward or to act on this pop-up when it appears.

 

[Joe4]

That is odd. Typically those messages pop to the top without you having to do anything.
What is showing up on top of it?
Do you have any automated VBA code that is running when the workbook is opened?

 

[Pinaceous]

Hi Joe4,

Yes, it is a very odd case.

The document is a vba coded where a generated expected message pop-up will introduce itself to the user.

However, Once the document is enabled, the other message box appears and it stays in the background and the user thinks that the document is frozen.

This doesn't happen all of the time, only when the excel thinks it is opened in the other SharePoint application.

Do you have any suggestions on how I can suppress this message box from happening?

FYI, I've tried:

Application.DisplayAlerts = False

And Now I'm Exploring this idea:

CreateObject("Shell.Application").MinimizeAll
'this way the user will see the message box pop-up

Please let me know if you can help!

Thanks,
pinaceous

 

[Joe4]

I have not worked with SharePoint at all, so I don't think I will be anyhelp there.

Is there any event VBA code running when this situation occurs, i.e. Workbook_Change, or one of the Worksheet events?

In which procedures exactly are you trying to place the VBA code you posted?

 

[Pinaceous]

Hi Joe4,

Is there a way to respond to a pop-up through vba code?

For example,

If Msgbox pops up then

Please let me know.


Thanks!
pinaceous