VBA MsgBox - Excel 2010

[cwunderlich]

I have a macro that runs and throughout the macro the user is presented with several vbYesNo message boxes. However, when they make their choice on each one, each message box stays displayed on this screen. Once they pick Yes or No (or Cancel), I would like the message box to go away and the code to continue to run. I thought it would just be a simple matter of putting Application.ScreenUpdating around the msgbox but this doesn't seem to be the case....

Any ideas?

 

[cwunderlich]

I should also note that throughout this macro I have application.screenupdating set = false. I think that if this were set = True for the whole macro then the message boxes would go away. However, I was screenupating to = false for this because it is opening a lot of files, etc...

 

[My Aswer Is This]

You could make a nice Userform which can be scripted to do what you want.

 

[cwunderlich]

I already have the necessary message boxes setup throughout the code. I would rather not use a userform, the message boxes are very simple and easy to work with as they are...

 

[Chris Mack]

I have a macro that runs and throughout the macro the user is presented with several vbYesNo message boxes. However, when they make their choice on each one, each message box stays displayed on this screen. Once they pick Yes or No (or Cancel), I would like the message box to go away and the code to continue to run. I thought it would just be a simple matter of putting Application.ScreenUpdating around the msgbox but this doesn't seem to be the case....

Any ideas?

So does ScreenUpdating = False for the rest of the macro?

I find that ScreenUpdating is sometimes a bit slow. Maybe try turning it off a few more lines after the MsgBox to give the MsgBox a chance to get out of the way?

Just a thought as I had a similar problem recently.

Chris.

 

[cwunderlich]

So does ScreenUpdating = False for the rest of the macro?

I find that ScreenUpdating is sometimes a bit slow. Maybe try turning it off a few more lines after the MsgBox to give the MsgBox a chance to get out of the way?

Just a thought as I had a similar problem recently.

Chris.

ugh, that is what I feared was the case... I can try that, it'll just be a hassle figuring out where the "right" spot is to insert ScreenUpdating = False back after the MsgBox. (right before the MsgBox, I have ScreenUpdating = True).

Thanks

 

[Chris Mack]

Yw.