用一个command button,点击后弹出输入框,取回输入值,如何写代码啊
sMSG为输入值,test为取回后调用,中间代码如何插。
Private Sub Command_Click()
Dim sMSG As String
Call test(sMSG)
End Sub
sMSG为输入值,test为取回后调用,中间代码如何插。
Private Sub Command_Click()
Dim sMSG As String
Call test(sMSG)
End Sub
if sMsg="" then exit sub ''如果sMsg=""说明用户取消或没有输入数据
MsgBox str
End SubPrivate Sub Command1_Click()
Dim sMSG As String
sMSG = InputBox("test", "xxx", "xxx")
Call test(sMSG)
End Sub