Hello, could some one please help me with the following:
In my Excel 2003 worksheet named: DMRS (copy attched with dummy data) I need MsgBox to pop-up when the user enters in any of the following text values:
Criteria:
1. If in column E the value = Hardcopy and in column F the value = Unclassified or Restricted, then a MsgBox "OCR" pops-up.
2. If in column E the value = Hardcopy and in column F the value = Confidential or Secret, then a MsgBox "CDR, OCR and SHT" pops-up.
3. If in column E the value is blank (no value) and in column F the value = Confidential or Secret, then a MsgBox "CDR" pops-up.
The data range of column E is E4:E65000
The data range of column F is E4:E65000
If any one could please help, it would be greatly appreciated.
Kind regards,
Chris![]()
Bookmarks