VBA code error

Hi everyone I have this code here it works fine but if I hit "clear content" on the cell the code ends and no longer works, any idea or tips on how to fix? this code converts hhmm to hh:mm am/pm. T...