I just started using modeless user forms myself. Did you write code for after the form appears? It sort of sounds like the form is appearing, then Excel is reaching the end of your code, and it is disappearing. I believe modeless userforms will only remain until code execution ends. (Unlike modal userforms that will remain until there is user action) Hope I could help!