Different behaviour of CommandButtons

Hello everyone,
I have experienced one problem I was not able to solve. I assigned this code to a CommandButton, which is placed directly in the sheet, and to another CommandButton, which is on a UserForm. The problem is that on the button in the sheet it works fine, but on the userform button I get an error: "Compile error: Variable not defined"

Any idea where the problem could be?

Please Login or Register  to view this content.

Thank you! Your helpfulness saved a lot of my time.