Stay on Top Message window

[miguems]

Hello:

Is there a way to have a MsgBox Stay on top while the user goes to a different application?. I've design a macro that pops a message giving the user some information needed to find a value they will need to input so the macro can continue to run. It would help them if this message could "stay on top" while they switch applications.

I've seen this:

OnTop = SetWindowPos(FrmID.hWnd, HWND_TOPMOST, 0, 0, 0, 0, FLAGS)

But I have no idea if this is what I'm looking for or how to blend it with a MsgBox.

Thank you for your time.

M.

 

[bk]

I don't know

you may be better off using a UserForm as a de facto MsgBox instead. On a UserForm, if you have set the "ShowModal" property to False, it will allow you to do what you're wanting to do while continuing to use Excel, but you said "another application"/not Excel. And I do not think the UserForm will stay up while in another application (although, I believe it will be just where you left it when you return to Excel).

I'm throwing out there, but this may be of no use to you due to the "other application" thing.

 

[miguems]

- thanks

Thanks BK, but yes, they do need to switch applications, they need to input the information fron the MsgBox to a web site form. I'm afraid they close the MsgBox by mistake and have to start all over and besides, it will be a lot easier if it stays on top, right?

Thanks anyways

M.