vba helper

I'm working on my excel of room booking system and vba. I followed the instruction and use a template from onlinepclearning websites. At first I run the vba without any troubles. But then I made some changes to the spreadsheet but I also changed in the vba as well. I need someone who can help me fix it but use the features i changed.