CODEWITHSUNDEEP
excelvba
Nick Razzleflamm
Nick Razzleflamm

Reputation: 41

How can i let the user work on an excel sheet while a message box is displayed on top?

Dim strMsg As String

strMsg = "Preperation completed. SAP Logon will open in 5 seconds! Please follow the instructions below to retrieve the ART file from SAP" & vbNewLine & vbNewLine
strMsg = strMsg & "1. Log into SAP using your Username and ID" & vbNewLine & vbNewLine
strMsg = strMsg & "2. Launch the 'ZMM_ART' Report" & vbNewLine & vbNewLine
strMsg = strMsg & "3. Insert the data from the 'DATA FOR SAP' Sheet to the relevent fields" & vbNewLine & vbNewLine
strMsg = strMsg & "4. Insert '0001' as the Location ID" & vbNewLine & vbNewLine
strMsg = strMsg & "5. Run the Report" & vbNewLine & vbNewLine
strMsg = strMsg & "6. Save the report as 'ART.xls' to the 'REQUIRED FILES' Folder in your Desktop" & vbNewLine & vbNewLine
strMsg = strMsg & "7. Click OK and close this message box" & vbNewLine & vbNewLine

MsgBox strMsg, vbInformation + vbSystemModal, "Instructions"

I need to display the above message box at some point of a macro. But i need the user to be able to work on the excel sheet while having the said message box on top. (ie: Copy data from the aforementioned 'DATA FOR SAP' Sheet and paste it in SAP) How do you suggest i should do that?

PS: Anyone wondering why, i don't have RFC authorization so this is what i'm reduced to.

Thanks!

Upvotes: 0

Views: 104

Answers (1)

user10765660
user10765660

Reputation:

You can't do that.

vbSystemModal - System modal; all applications are suspended until the user responds to the message box.

Upvotes: 2

Related Questions