How can i unload userform1 and show userform2 correctly?

[MisterExcellent]

Hello all!

How can i show then unload userform1 and show userform2 correctly?

The first userform should be shown, if the listbox is filled.
If the listbox is filled and the userform1 is shown, i can unload this userform and show userform2 with a commandbutton.
If there are no data (the listbox is empty) it should unload and show the second userform.

My solution doesn't work:

If ListBox1.ListCount = 0 Then UserForm1.Hide [COLOR=DarkOrange]And Userform2.Show[/COLOR]
    Application.OnTime Now + TimeValue("00:00:02"), "ThisWorkbook.Close"
Else
    Me.Show
End If
End Sub

I look forward to your approach..
Bye for now..

Version: Excel2003

 

[MisterExcellent]

Over an suggestion I would be very happy

 

[MisterExcellent]

Who can help me?

 

[MisterExcellent]

Help me please

I might have expressed myself unclear, the problem is if I want to open Userform1, which is closing itself. Then I want to open Userform3 but if the Listbox on the Userform3 is not filled, it should be shown for 2 seconds, close itself and Userform2 should open itself.

How can I do this? Help me, please

 

[MisterExcellent]

Solved!

If the Listbox is empty then i have to load UF2 & hide UF2 and then show UF3.

A lot of thanks to rudfaden