I need to dynamically generate a UserForm in VBA. Also need to make it modeless. Using
VBA.UserForms.Add(TempForm.name).Show(vbModeless)
DoEvents
causes the form to appear briefly and then disappear...
Thanks in advance for any help
Robin

Hi Robin,
   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!

I was wondering if there was some way to prevent the code from running to completion like that... so I can generate multiple modeless forms dynamically so the user can do stuff in parallel...

Thanks