How to use before close function with multiple condition are met

Hi,
I am new to programming. I am trying to write a code for excel sheet form, where multiple individuals have to give their feedback, and my target is creating a sheet in which if one individual respond to certain query as “No” then he should mention his reasons in the corresponding Colum before closing the sheet.
A message box should appear to prompt him that he has to fill the corresponding required field

For example:
If someone selects “No” from the drop-down selection and he does not put a reason for this then he should get a prompt massage and sheet shouldn’t be close until he fills the reason for that.
This is here I have reached so for. it will be appreciated if someone could helpImage.jpg


Private Sub Workbook_BeforeClose(Cancel As Boolean)

If Cells(8, 4).Value = "" Then
MsgBox "Please fill the Remarks "
Cancel = True
End If

End Sub
Private Sub Workbook_Open()
End Sub

Try this

Please Login or Register  to view this content.

Thanks!

It really helped. I am thankful