uaku
04-26-2011, 11:08 AM
Hi,
I am trying to populate userfrom Labels from worksheet range. I have more than 25 labels so I want to write a macro, I tried below code but it did not work
Private Sub UserForm_Activate()
Dim Val As Range
No = 1
For Each Val In Range("A6:C6")
Labels = "Lable" & No
MsgBox Labels
Labels.Caption = Val
No = No + 1
Next
End Sub
Thanks for your help
Aku:think:
I am trying to populate userfrom Labels from worksheet range. I have more than 25 labels so I want to write a macro, I tried below code but it did not work
Private Sub UserForm_Activate()
Dim Val As Range
No = 1
For Each Val In Range("A6:C6")
Labels = "Lable" & No
MsgBox Labels
Labels.Caption = Val
No = No + 1
Next
End Sub
Thanks for your help
Aku:think: