Sub test()
If IsNumeric(ThisWorkbook.Worksheets(1).Cells(2, 1)) And Len(ThisWorkbook.Worksheets(1).Cells(2, 1)) = 10 Then
MsgBox "Is number"
Else
Exit Sub
End If
End Sub
追问你好,如果条件成立就不做任何动作,程序向下进行,该如何改 也就是第三行的 msgbox"is number"这句应该如何改呢,谢谢
追答Sub test()
If IsNumeric(ThisWorkbook.Worksheets(1).Cells(2, 1)) And Len(ThisWorkbook.Worksheets(1).Cells(2, 1)) = 10 Then
MoreFunction
Else
Exit Sub
End If
End Sub
Private Function MoreFunction()As String
MsgBox "Is number"
End Function
不知道是不是你要的?
本回答被提问者采纳