troubleshooting Question

How can I exclude a range of cells from having the MsgBox warning pop-up

Avatar of gdunn59
gdunn59 asked on
Microsoft ExcelVBA
6 Comments1 Solution58 ViewsLast Modified:
I have the following vba code in excel that pops up a warning msgbox if a user tries to enter data in these 2 cells (Columns L & M) and there is nothing populated in another Column.  The problem is the msgbox should only pop up if the user is selecting one of the 2 columns (L & M) starting on Row 8 and below.

If Target.CountLarge > 1 Then Exit Sub

If Target.Column = 12 Or Target.Column = 13 And Target.Row > 7 Then
   If Cells(Target.Row, "F") = "" Then
      MsgBox "You cannot update SubmittedDate or Comments2 because this Invoice has not had an eBill file generated yet.", vbExclamation, "InvElecHistoryID Missing!"
'      Cells(Target.Row, "F").Select
   End If
End If

How does the code need to be changed to adapt to this?



Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros