Q: most efficient way to feed textboxes from worksheet and vice versa

[Tom Ogilvy]

for activeX controls on a worksheets with sequential names as an example:

for i = 1 to 50
With Worksheets("Sheet1")
.OleObjects("TextBox" & i).Object.Value = .Cells(i,2)
.OleObjects("Label" & i).Object.Caption = .Cells(i,1)
End With
Next

 

[count]

Hi,
I believe this has been measured some time ago. I need to feed more than 50
controls (textboxes and label.captions mostly) real fast.
Is there a clear winner among the methods?

TIA
Paul

 

[Bob Phillips]

50 is trivial. Any way, manually loading, or linking to worksheet cells
should be fast enough.

--

HTH

RP
(remove nothere from the email address if mailing direct)