Add this code (Red Font ) to the existing code.
![]()
Set Rc = Nothing For Each cel In Range("E8:E29") If InStr(1, cel, "*") > 0 And cel.Offset(0, 1) = "" Then MsgBox ("Please fill all mandatory fields") Exit For End If Next cel End Sub
Add this code (Red Font ) to the existing code.
![]()
Set Rc = Nothing For Each cel In Range("E8:E29") If InStr(1, cel, "*") > 0 And cel.Offset(0, 1) = "" Then MsgBox ("Please fill all mandatory fields") Exit For End If Next cel End Sub
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks