首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >VBA MsgBox IF语句?

VBA MsgBox IF语句?
EN

Stack Overflow用户
提问于 2022-10-13 07:08:33
回答 1查看 44关注 0票数 0

我正在尝试为一个具有YES/NO响应的vba MsgBox设置一个IF语句。有可能吗?这就是我所拥有的:

代码语言:javascript
复制
Sub EmailAttachments()

Dim Msg001 As String
Dim Msg002 As String

Msg001 = "Continue creating your email"
Msg002 = "Save your attachments prior to creating an email"

MsgBox "Have you saved your attachments", vbYesNo, "ATTENTION!"

If vb = Yes Then
MsgBox Msg001, vbOKOnly, "CONTINUE"
Else
MsgBox Msg002, vbOKOnly, "EMAIL NOT CREATED"
End if

End Sub
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2022-10-13 07:12:48

请用下一条路:

代码语言:javascript
复制
Sub EmailAttachments()
 Dim Msg001 As String, Msg002 As String, answer As VbMsgBoxResult

 Msg001 = "Continue creating your email"
 Msg002 = "Save your attachments prior to creating an email"

 answer = MsgBox("Have you saved your attachments?", vbYesNo, "ATTENTION!")

 If answer = vbYes Then
        MsgBox Msg001, vbOKOnly, "CONTINUE"
 Else
        MsgBox Msg002, vbOKOnly, "EMAIL NOT CREATED"
 End If
End Sub
票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/74051719

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档