Prompt to Select an Option (Yes/No) if User Leaves Cell Blank

[manona]

Hi,

I'm creating a workbook that will be used by various users. Certain users will be accessing this workbook only to update information in certain tabs. In those tabs, there are cells that cannot be left blank; there needs to be a yes or no.

Is there any way to prompt a yes/no if the user is about to leave the tab and has not addressed those cells?

I have some basic VB experience, I usually manage to get around, but am not 100% familiar with all the lingo yet.

Thank you for your time and help in advance, it's really appreciated!

 

[Jeffrey Mahoney]

Of course, you will need to change the range address and the sheet name. Place this code in the Sheet Level module under Microsoft Excel Objects.

Private Sub Worksheet_Deactivate()  
  If UCase(Range("G5").Value) <> "YES" And UCase(Range("G5").Value) <> "NO" Then
    
    Sheets("sheet1").Activate
    Range("G5").Select
    MsgBox "Hey!  I need an answer."
    
  End If
  
End Sub