Modeless form disappears on deleting sheet

W

Walter Martin

Hi,

I am using a modeless form to control my application. Everything works
fine until I use the form to delete a sheet - as soon as this happens,
the form disappears and VBA stops running. Any ideas very much
appreciated. I am using excel 2002

many thanks

Walter
 
H

Howard Kaikow

A modeless Userform will disappear immediately as soon as the code within
the Userform is finished running.
You have to re-organize your code to keep the Userform going until you
really want it to go away.

As I recall, my SDI/MDI example at
http://www.standards.com/OhMyWord/VBACodeSnippets.html might show how to do
this.
I have not looked at the code in some time, but it might help you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Mis-performing MP4 files in Mac PPT 1
Modeless form takes 'focus' 3
Using a modeless form to show status 2
"Coult not find specified object" and "Path-File access error" messages 3
Create form with checkbox les that expand and collapse sections of the form? 0
Modeless UserForm 5
Bring my modeless userform to the foreground??? 9

Top