Microsoft Office Forums - View Single Post - [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

p45cal · 11-03-2018, 06:51 AM

change:

Code:

    If Not Intersect(shp.TopLeftCell, RngToCheck) Is Nothing Then shp.Delete

to:

Code:

  If shp.Type <> msoFormControl Then
    If Not Intersect(shp.TopLeftCell, RngToCheck) Is Nothing Then shp.Delete
  End If

and you can keep your data validation.