Im trying to assign the value in excel user form thought loop.
Name of the textboxes are TB1,TB2,TB3.. TB22 .
Below is the code which Im using ,but its not working.
For num = 1 To 22
txtbox_val = "TB" & num & ".value"
txtbox_val = num
The same thing I wanted to do with the label and the names of the label are
Please help me on this.