| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Hours 0, If Volume <= 0,(and vice-versa) then.... | Excel Worksheet Functions | |||
| I want columns of worksheet to become rows and vice-versa. | Excel Worksheet Functions | |||
| From pricelist to productslist and vice versa... | Excel Discussion (Misc queries) | |||
| Outlook task from xls or vice versa | Excel Programming | |||
| How do I reference a worksheet name in a cell, or vice versa? | Excel Discussion (Misc queries) | |||
Linear Mode
