most efficient way to feed textboxes from worksheet and vice versa
 

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

--
Regards,
Tom Ogilvy


"count" wrote in message
...
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

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

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

most efficient way to feed textboxes from worksheet and vice versa
 

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)


"count" wrote in message
...
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