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
Written by Siddhant Chothe
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Vba
Authors
engineersmnky
1.698K
punksteez
1.256K
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#