I'm afraid there's another glitch of my own making. In order to familiarize the teachers in filling up the form, I copied it with the initial cods and distributed to the teachers to practice on. But when we ran the macro, there's an error message of
'Run-time error 1004, Application-defined or object-defined error'.<If Not Intersect(shp.TopLeftCell, RngToCheck) Is Nothing Then> This was colored yellow. According to my google search, this might be the result of copying without saving the file afterwards. How do I correct the error?