Two Cells required before saving or closing.

[oparfait]

Hello everyone, Im new to editing in VB with excel.... Is there a way to make cells C3 (employee name) and C5 (employee ID) required before saving or exiting on excel. We use excel to track days worked and our employees sometime forget to fill these two fields out before submitting to payrole.

[ragulduy]

You can use something like this code. Note, it needs to be saved in the ThisWorkbook object in your vba project (Not a new module)

Please Login or Register  to view this content.

[oparfait]

Thanks so much yudlugar I used this code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim whatCell As String
whatCell = "C3"
If Sheets("Monthly Report").Range(whatCell).Value = "" _
Or IsEmpty(Sheets("Monthly Report").Range(whatCell)) Then
MsgBox "Please enter your name in box " & whatCell
Cancel = True 'cancels the save event
Exit Sub
End If
whatCell = "C5"
If Sheets("Monthly Report").Range(whatCell).Value = "" _
Or IsEmpty(Sheets("Monthly Report").Range(whatCell)) Then
MsgBox "Please enter your SAP in box " & whatCell
Cancel = True 'cancels the save event
Exit Sub
End If
End Sub

Now I just need to figure out if you can prompt them to make the changes both before they save and before they exit.

[ragulduy]

Put the same thing as a beforesave event:

Please Login or Register  to view this content.

[oparfait]

Nevermind I got it, thank you so much