I have a spreadsheet that that has drop-down options in most cells. In one particular column the options are yes/no and I want to set something up where if yes is choson, people can not close or save the spreadsheet without completing the next column. I have managed to do this for one cell only but can't work out how to do this for the whole column.
So at the moment in box af2, if yes to chosen it won't let me close/save until I complete ag2. But if I go to af3 it will let me save fine. What I need is this to work for every cell in column af.
The current vsb setting is as follows.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If [AF2].Value = "Yes" Then
MsgBox "There MUST be an entry in Level of Investigation!", vbOKOnly, "Entry Reqd"
[AG2].Select
Cancel = True
End If
End Sub
Hope that makes sense and any help would be greatly appreciated.
Thanks.
So at the moment in box af2, if yes to chosen it won't let me close/save until I complete ag2. But if I go to af3 it will let me save fine. What I need is this to work for every cell in column af.
The current vsb setting is as follows.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If [AF2].Value = "Yes" Then
MsgBox "There MUST be an entry in Level of Investigation!", vbOKOnly, "Entry Reqd"
[AG2].Select
Cancel = True
End If
End Sub
Hope that makes sense and any help would be greatly appreciated.
Thanks.
