OK, got the triangles working. Now I'm working on what users might put in, even if they get it a bit wrong.
For example, you wanted LLLE scrapped, but this can still be interpreted unambiguosly, so now the code accepts it, but re-writes a 'standardised' version LLEL to the sheet. The same applies to LLTI; it becomes LTIL. There are several more…

This has brought up something else. I'd like to know a bit more about what LE and TI actually are (in the real world), so a bit of narrative on those please.

• Is LE something that can happen EITHER in the morning OR in the morning on the same day?
• Can LE happen BOTH in the morning AND the afternoon?
• If LE happens does it automatically exclude one or more of the other things (L,X,C,TI or anything else) happening on the same morning/afternoon/day? If so, which things?

The same for TI:

• Is TI something that can happen EITHER in the morning OR in the morning on the same day?
• Can TI happen BOTH in the morning AND the afternoon?
• If TI happens does it automatically exclude one or more of the other things (L,X,C,LE or anything else) happening on the same morning/afternoon/day? If so, which things?

Could you give an answer to each/all of the bulleted points please.
I'm sorry to ask you so many questions - I'm just trying to make this as useful and robust as possible.

[quote=p45cal;135050]OK, got the triangles working. Now I'm working on what users might put in, even if they get it a bit wrong - The input error could be prevented by a validation list later on when all the codes shall have been finalized. But I guess the list would over populate the cells and might cause the processing to slow down. I don't see anything wrong with the system re-writing the error into its standard code (i.e. from LLLE to LLEL)

• Is LE something that can happen EITHER in the morning OR in the morning on the same day? - LE refers to a learner who enrol beyond the cut-off date, in this school year, the cut off date is June 4. There is no morning or afternoon LE. A LE learner comes from the same school.

Is TI something that can happen EITHER in the morning OR in the morning on the same day? - TI refers to transfer in learners, those who come from other schools, so there is no morning or afternoon for TI.


The reason for the presence of the LE, TI, DRP, TO in the form is their effect on the total daily attendance. Say on June 4, there were 10 learners but during the month a learner came in, registered as LE on June 8, making the total daily attendance on Jun 8-31 to 11 learners.


I should be the one to apologize for providing piecemeal information that have relevance to the program.

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?