excel vba 按啟動事件鈕後如果修改B2:C4儲存格範圍內的資料時，會檢查是否為正整數，否則就顯示 請輸正整數!?
回答 (2)
2017-05-27 2:44 pm
先申請個dropbox吧: https://db.tt/DCCgE4JCbb
2017-05-25 10:37 am
For Each i In Range("B2:C4")
If i.Value < 0 Then
s = "請輸入正整數" & Chr(i.Column + Asc("A") - 1) & i.Row
MsgBox s
End If
Next i
If i.Value < 0 Then
s = "請輸入正整數" & Chr(i.Column + Asc("A") - 1) & i.Row
MsgBox s
End If
Next i
收錄日期: 2021-05-04 02:22:25
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170524054248AAYarvw