label1.caption

Hi I have 2 forms. UserForm1 and UserForm2. Do I need to say UserForm2.Label1.Caption or just Label1.Caption I did "Label1.Caption" and everything work fine, it is not effecting the UserForm1 The code below is for UserForm2 Private Sub myadd_Click() UserForm2.Label1.Caption =...

This code belove will take random cells text to Label1.Caption in Form Now i want Lebel1.Caption will appear Cells(1,4) 5 seconds then cells(2,4) 5 seconds then cells(3,4) 5 seconds .... to the end row. Please help me to do that, thanks in advance./. Private Sub Userform_Initialize()<code...

[/URL][/IMG] Label1 is the white box down and right i need to put in Label1 ,value of range("Q3") tried ...Label1.Caption = Sheets("WORK").Range("Q3") but it keeps sleeping Please help,thanks for your time

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...