Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I add controls to an array in a For Each loop can I be sure that the
order of these controls in the array is always the same? They will be added like for example this: Sub AddTextBoxesToArray(oForm As UserForm, lStart) Dim ctl As MSForms.Control Dim i As Long i = lStart For Each ctl In oForm.Controls If TypeName(ctl) = "TextBox" Then Set TextBoxes(i).objTextBox = ctl i = i + 1 End If Next End Sub I can be sure the start element is always the same as this is a Public constant, but how about the rest? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
accesing controls in for each loop | Excel Programming | |||
How to loop through controls on a MultiPage | Excel Programming | |||
Loop through objects/controls on worksheet | Excel Programming | |||
loop through controls | Excel Programming | |||
What order does VBA look at userform controls? | Excel Programming |