how to visible label on a user form? [SOLVED]

[mahaveer]

actually i have a button on sheet1. when i press it then userform1 open.


and on userform1 i have 4 labels... but all are unvisible now my problem is that...

i want when my userform open then after 1 second the first label visible = true...and the same after next 1 second the second label visible = true...same like as all the labels visible = true. automatically...


but how?

i dont know....


can any one help me......


Regards

CA Mahaveer Somani

 

[DaveTurton]

just a guess but would something like this work?


Double click on the userform1 and paste this:

[pre]

Private Sub UserForm_Activate()

Me.Label1.Visible = False
Me.Label2.Visible = False
Me.Label3.Visible = False
Me.Label4.Visible = False

Application.Wait Now + TimeValue("00:00:01")
Me.Label1.Visible = True
DoEvents
Application.Wait Now + TimeValue("00:00:01")
Me.Label2.Visible = True
DoEvents
Application.Wait Now + TimeValue("00:00:01")
Me.Label3.Visible = True
DoEvents
Application.Wait Now + TimeValue("00:00:01")
Me.Label4.Visible = True
DoEvents
End Sub

[/pre]

 

[mahaveer]

thanks dave bro u solved my very big query......thank you alot dear....


Regards

CA Mahaveer Somani