A big thanks in advance, I have set up a worksheet to collect data and used validation to control the type of data allowed to be entered. I have a problem with some required data not being entered by staff. I have set up "Missing Data" script which actions a message box and it works when tested, what I can't work out is how do I have the script stop and return back to the worksheet for the fields to be entered. The segment of the script is below.
'Check all required data is entered
Dim MissingData As Integer
MissingData = Worksheets("Template").Range("O7").Value (This is a if(isblank(A1,1,0)) formula)
If MissingData <> 0 Then
MsgBox "There is missing required data. Please complete all * fields”"
Application.Goto Reference:=Worksheets("Template").Range("C2") (This doesn't work.)
Else
End If Else
End If
Hope this makes sense.
'Check all required data is entered
Dim MissingData As Integer
MissingData = Worksheets("Template").Range("O7").Value (This is a if(isblank(A1,1,0)) formula)
If MissingData <> 0 Then
MsgBox "There is missing required data. Please complete all * fields”"
Application.Goto Reference:=Worksheets("Template").Range("C2") (This doesn't work.)
Else
End If Else
End If
Hope this makes sense.