Blank userform

[wmbb]

I want to use a userform to display a message during the macro-runtime.

I wanted to use code:
UserForm2.Show (false)

but this displays a blank userform !
what goes wrong ?

 

[HarleyQuinn]

What is on Userform2?

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[PHV]

You may add some DoEvents calls in your macro.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wmbb]

In the userform are a textbox, a label and a picture.
Using just userform2.show does display the right form but the macro is waiting for input.
closing userform2 manually triggers the macro to continue.

 

[combo]

Use repaint:

With UserForm2
    .Show False
    For i = 1 To 100
        .Label1.Caption = i
        .Repaint
        For j = 1 To 10000000 ' depending on the processor
        Next j
    Next i
End With
Unload UserForm2

combo

 

[wmbb]

Thnx for your help.

I've replaced the code "userform2.show (false)" with

With UserForm2
    .Show False
    .Repaint
End With

and this is working although I don't understand why the first option doesn't work.