• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show Userform the same time process other codes

Dhamo

New Member
Hi,


Can any one of you please let me know how to run an userform and run other macros in background.


Eg.


Sub CmBtn_click()

call Processing_UF

--

--

'do other stuffs

--

--

unload Processing_UF

Msgbox "Process Completed"

End Sub


When I execute this macro, the Processing_Uf is keep running. But I want the Processing Userform should show And the same time other macro codes should execute its commands.


Please reply if you need any more inputs.

Thanks.!
 
Hi,


You can show the userform modelessly which will allow other code to run while the userform is showing. You can either do this explicitly in your code when you show the userform, eg:

[pre]
Code:
UserForm1.Show vbModeless
[/pre]
Or you can do it at design time by setting the userform's ShowModal property to False in the property window.
 
Hi,


Do you mean that the userform doesn't render properly? If that's the case use UserForm1.Repaint, otherwise you'll need to describe in more detail the problem.
 
Back
Top