..again, thanks to this forum...great people....
I have my VB code working great - spreadsheet now requires data entry in a specific cell and that requirement has been delayed until a certain date with a IF THEN statement. Thanks to all that helped!!
I am now trying to broaden the "beforesave" requirement to multiple cells in the same workbook/worksheet. In the below VB statement, I don't know where to insert this additional command to require that a second cell have data entered into it before saving. The cell on the "Request for PTM" worksheet is H12.
I would need a second message to appear relating to that specific cell as well; similiar to first message "Current Installed Irr. System Entry Required"
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Date < #11/2/2008# Then Exit Sub
If IsEmpty(Sheets("Request for PTM").Range("H11").Value) Then
Sheets("Request for PTM").Activate
Range("H11").Select
MsgBox "Estimated Order Date Required"
Cancel = True
End If
End Sub
Thanks for all the great help!! You guys are awesome!!!
Bookmarks