Sub 判断格式并提示()
Dim i As Long
For i = 3 To Range("H" & Rows.Count).End(xlUp).Row
If Not Range("H" & i).Text Like "######-#####-####" And Range("H" & i) <> "" Then
Range("H" & i).Interior.Color = RGB(255, 0, 0)
'MsgBox Range("B" & i) & "原料报送码为 " & Range("H" & i) & "第" & i & " 行的H列格式错误"
End If
Next i
End Sub
有格式问题的设置颜色提醒也行。
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i As Long
For i = 3 To Range("H" & Rows.Count).End(xlUp).Row
If Not Range("H" & i).Text Like "######-#####-####" And Range("H" & i) <> "" Then
Range("H" & i).Interior.Color = RGB(255, 0, 0)
Else
Range("H" & i).Interior.Color = RGB(255, 255, 255)
End If
Next i
End Sub
------------------------
也可以用这个把代码放在对应的工作表代码中。单元格有问题会红色提醒,修改对了格式自己会设置为白色