Firstly you have code in thisworkbook object that is placed outside of any routine. I think the code should be in the workbook open event.

The error you highlight is cause by using the same name for a control on the userform and a const declared within the scope of the userform object.

Either change the names or move the consts into a standard code module and declare as public consts.