Since this is a class assignment, I'll give a suggestion but no solution.
Have you tried using a "worksheet_change" event?

"B-manninja" wrote:

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero