Last Updated: February 25, 2016
·
370
· sidnc86

Don't use ShowModal as method name in VBA UserForm Module code

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