auto generate a comment box based on a cell value that has variable reference cells

I have been given the following code and it works great. I now need to adapt it to the following scenario:

In the attached sheet, the user has to select either, "Suburban" or "Squad" in row 5.
If the user selects, "Suburban" I need this script to compare the values they enter in a given row to the value in column "B".
If the user selects, "Squad" I need this script to compare the values they enter in a given row to the value in column "C".

Look at row 48, for example. If the user enters, "Suburban" in cell D5 then the value they enter in cell D48 should equal "1". If it does not equal "1" then it should proceed with the adding of a comment. Conversely, if the user enters, "Squad" in cell D5 then the value the enter in cell D48 should equal "2". If it does not equal "2" then it should proceed with the adding of a comment.

WHEW! Clear as mud?

Please Login or Register  to view this content.

I had only included the one sheet in the last attachment, and did not think about it confusing/clouding the big picture. I have attached the whole book this time. The auto_open basically just puts everything back at the beginning each time someone opens the file.

The code I had included in the original message was from another book and works fine for that application. I am just trying to convert it to the needs of this book. The revised code would be placed in the, "PRIMARY EQUIPMENT" and "RESERVE EQUIPMENT" sheets as the other sheets have different requirements.