On a userform, can you show a label for a period of time?

[spyrule]

Hello,

I have a userform that when completed tells the user that either a row was updated, or a new row was inserted via two simple labels that appear with the information as required.

Is there a way to show these labels for only 2-4 seconds before it automatically gets hidden?

 

[mse330]

Hello spyrule

Try the below code, of course has to be adjusted based on your UserForm label names & the caption

Private Sub CommandButton1_Click()

With Label1
    .Visible = True
    .Caption = "Test"
     Application.Wait (Now + TimeValue("00:00:03"))
    .Visible = False
End With

End Sub