Emre
Emre

Reputation: 121

How to keep msgbox always on top in vba?

While my macro runs, I do my other works. But then when msgbox pops out stays behind my other windows.

How can I see it on top, when it pops out?

Thank you.

Upvotes: 7

Views: 9771

Answers (2)

RobBour59er
RobBour59er

Reputation: 1

Add an exclamation mark to the message:

MsgBox "Your message!",6 +vbSystemModal, "Title of Msg..."

Upvotes: -1

JC Guidicelli
JC Guidicelli

Reputation: 1316

add system modal parameter vbSystemModal:

MsgBox "Your message!", vbSystemModal

Upvotes: 10

Related Questions