Edward, thank you so much!
I was having this problem and I'm not too familiar with VBA and was desperate haha. I used your solution in the "add" button code and works perfectly. It doesn't crash anymore.