Update many text boxes at once dynamically

[crispyhamblin]

Hi guys,
I've been struggling around for about 2 hours now with no luck, I'm sure this is easy but could someone please spare me from throwing my laptop out the window!

I have lots of text boxes that are named similarly but with different numbers at the end... I'd like to update all of them at the same time. I've tried Me.Controls in a loop but kept getting error messages. It doesn't seem to like it if the name is created "on the fly" with some sort of "DocName" & CStr(i). At the moment I'm resorting to this:

DocName1.Value = Doc(1)
DocRev1.Value = DocRev(1)
DocNewRev1.Value = DocNewRev(1)
DocName2.Value = Doc(2)
DocRev2.Value = DocRev(2)
DocNewRev2.Value = DocNewRev(2)

[mehmetcik]

Hi

I do this regularly with userforms and have no issues.

This is the code I use:

For Count = 1 To 66
 Me.Controls("Textbox" & Count).Text = Cells(1, Count).Value
Next

I am reading from a specific row in this version