首页 文章

当消息框显示在顶部时,如何让用户在Excel工作表上工作?

提问于
浏览 1063
0
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"

我需要在宏的某个位置显示上面的消息框 . 但我需要用户能够在excel表上工作,同时将所述消息框放在最上面 . (即:复制上述'DATA FOR SAP'表格中的数据并将其粘贴到SAP中)您如何建议我应该这样做?

PS:有人想知道为什么,我没有RFC授权,所以这就是我所贬低的 .

谢谢!

1 回答

  • 2

    你不能这样做 .

    vbSystemModal - 系统模态;所有应用程序都将暂停,直到用户响应消息框 .

相关问题