MsgBox Interactive

  • Thread starter Thread starter jamesbehling
  • Start date Start date
J

jamesbehling

Is there a way to display a message box (Msgbox) but allow the user to
do something in the spreadsheet? For example, I want to display a
msgbox that tells the user to do steps 1, 2, and 3, then click the OK
button. I found something about vbApplicationModal but unable to
understand how to use it.
 
You can display a mesage in the Status Bar and still give the user control
over the worksheet:

Sub Macro1()
Application.DisplayStatusBar = True
Application.StatusBar = "Hello World"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint vba to insert name on Quiz Certificate in PowerPoint 0
Simple Powerpoint Vba Macro Problem 1
vbApplication-NOT-Modal 7
How to inhibit non-interactive MsgBox display 4
excel internet explorer interaction appearance 3
Date Warning MsgBox 2
Excel2007; workbooks.count is not counting all open workbooks 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top