I have a userform with 100 textboxes on it and another form with 100
labels. The textboxes are filled with numbers 1 to 26.

I want to change the label captions on the second form to the alpha
equivalent of the number in the textbox, ie if textbox 27 has 5 in it,
the caption for label 27 should be E.

Also if I change say textbox 45 from 7 to 22, I want this cahnge to be
reflected in the caption for label 45.

I understand this could be done through control arrays but I can't get
them to work for textboxes.

Could someone help please?
Thanks
Chris