Show Userform the same time process other codes

[Dhamo]

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.!

 

[Colin Legg]

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]

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.

 

[Dhamo]

Thanks Colin.


But the 'Processing_UF.show vbmodeless' is showing the blank userform.

 

[Colin Legg]

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.