Não use ShowModal como nome do método no código do módulo VBA UserForm

If you use ShowModal as method name within a VBA UserForm module, you are going to get Invalid Property compile error. This error points to no line within the module. So you are not going to get any clue what so ever. Try using some other name. More info on ShowModal property of UserForm: http://msdn.microsoft.com/en-us/library/office/gg251819%28v=office.15%29.aspx