dim time as currency
dim j as long
If j < 50 Then
time = " &CCur(0) & CCur(j / 50)&"
Else: time = " & CCur(j / 50)&"
End If
If MsgBox("按钮按下时间为time 秒,确定发送吗?", 49, "提醒") = vbOK Then
运行时提示错误:类型不匹配,调试指向time = " &CCur(0) & CCur(j / 50)&",请问我要如何修改才能达到我想要的效果,请大哥大姐们来帮帮小妹,我的意图主要是想j < 50是,能把整数部分的"0"显示出来
dim j as long
If j < 50 Then
time = " &CCur(0) & CCur(j / 50)&"
Else: time = " & CCur(j / 50)&"
End If
If MsgBox("按钮按下时间为time 秒,确定发送吗?", 49, "提醒") = vbOK Then
运行时提示错误:类型不匹配,调试指向time = " &CCur(0) & CCur(j / 50)&",请问我要如何修改才能达到我想要的效果,请大哥大姐们来帮帮小妹,我的意图主要是想j < 50是,能把整数部分的"0"显示出来
dim j as long
If j < 50 Then
time = CCur(0) & CCur(j / 50)
Else: time = " & CCur(j / 50)&"
End If
dim j as long
If j < 50 Then
time = " &CCur(0) & CCur(j / 50)&"
Else: time = CCur(j / 50)
End If
dim j as long '...................If j < 50 Then
time = "0" & CCur(j / 50)
Else
time = CCur(j / 50)
End IfIf MsgBox("按钮按下时间为 " & time & " 秒,确定发送吗?", 49, "提醒") = vbOK Then '..........................end if
dim time as string
dim j as long '...................If j < 50 Then
time = "0" & CCur(j / 50)
Else
time = CCur(j / 50)
End IfIf MsgBox("按钮按下时间为 " & time & " 秒,确定发送吗?", 49, "提醒") = vbOK Then '..........................end if
Dim j As Long
If j < 50 Then
time = 0 & CCur(j / 50)
Else
time = CCur(j / 50)
End If
If MsgBox("按鈕按下時間為" & CStr(time) & "秒,確定發送嗎", 49, "提醒") = vbOK Then
End If
這樣就沒錯啊,這不就是你想要的結果嗎?
time = "0" & CCur(j / 50)
'………………
看来lz真的不知道几个基本的类型。
這是j=30時的運行結果
---------------------------
提醒
---------------------------
按鈕按下時間為0.6秒,確定發送嗎
---------------------------
確定 取消
---------------------------
這是j=60運行時的結果
---------------------------
提醒
---------------------------
按鈕按下時間為1.2秒,確定發送嗎
---------------------------
確定 取消
---------------------------
你不是要這樣的結果嗎?怎麼不行,我算服你了
那就這樣了
Dim time As String
Dim j As Long
If j < 50 Then
time = CCur(j / 50)
Else
time = CCur(j / 50)
End If
If MsgBox("按鈕按下時間為" & time & "秒,確定發送嗎", 49, "提醒") = vbOK Then
End If
Dim j As Long
If j < 50 Then
time = "0" & CCur(j / 50)
Else
time = CCur(j / 50)
End If
If MsgBox("按鈕按下時間為" & format(CStr(time),"0.0") & "秒,確定發送嗎", 49, "提醒") = vbOK Then
End If
实在不行,就这样