PDA

View Full Version : Help needed Macro Runs after userform is closed



rajkumar
03-24-2009, 11:51 PM
Hi Experts,

I need a help on my macro. I have a data which need to be split by description, for which i got a macro from net which is doing the job fine.

But i want to use a swf embedded user form as progress screen.

What happens i run the macro in my file is, it launches the user form, but the macro runs only after the user form is closed.

How i can show the user form while running the code in background.

Any help would be highly appreciated. I ahve attached a sample workbook here.

Thanks & Regards
Raj :hi:

mikerickson
03-25-2009, 06:54 AM
Is your userform modeless?

rajkumar
03-25-2009, 07:03 PM
Hi mikerickson,

It is a simple excel user form with shock wave flash object.

Raj

mikerickson
03-25-2009, 08:01 PM
Try opening it modeless.