Message Box focus

[ovlia1286]

VB masters,

I have a program created in VBA (Excel) which displays a message box to the screen. The message box is a reminder that a certain excel file should be modified before the user should continue. However, when the message box is displayed, it doesn't let me click on anything in Excel (ie pull down menus, etc). I think it may have something to do with the message box having focus, but I'm not sure.

Thanks in advance for your help,

VO

[kfcSmitty]

messagebox is meant to stop the user from doing what they're doing and prompt them.

If you want to allow the user to click outside the messagebox, you will need to use a form, and format it to look like a messagebox, rather than using the msgbox function

[RobDog888]

Sounds like you do want it to stop the user from continuing on without saving work. The solution, format the msgbox as a
vbYesNo+vbQuestion msgbox. This way they can click Yes to save that file or no to dismiss it and not save.

I depends on how you want your app to function.

[ovlia1286]

I will just use vbYesNo to control the process.... Thanks for your quick reply guys

VO