I have created a multipage userform and on each page there are going to be 20 sets of four option buttons, each set has a label. There are also other controls on each page
Currently the labels are all stored on a sheet ie multipage.page1 labels are on sheet1 "A1:A20"
My question is how do I rename the labels with the contents of the sheet, I have tried the following but other controls get renamed as well
Code
Private Sub LoadIt()
I = 1
For Each Control In Me.Controls
With Me
Control.Caption = Range("A" & I)
I = I + 1
End With
Next Control
End Sub
Thanks