- Joined
- May 28, 2010
- Messages
- 2
- Reaction score
- 0
Hi,
I have a spread sheet that people insist on leving cells blank! Is there vba code to make all cells mandatory?
There was this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$2" Then Exit Sub
If Target.Value = "" Then
MsgBox "Input required!", vbInformation + vbOKOnly, "Warning"
Target.Activate
End If
End Sub
But I want it to go from cell A2 - I2?
Please help?
I have a spread sheet that people insist on leving cells blank! Is there vba code to make all cells mandatory?
There was this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$2" Then Exit Sub
If Target.Value = "" Then
MsgBox "Input required!", vbInformation + vbOKOnly, "Warning"
Target.Activate
End If
End Sub
But I want it to go from cell A2 - I2?
Please help?