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

--
Gary's Student


" wrote:

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.