| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each Next loop Through Userform
Before I get into it, I think the issue may be the lowercase 'textbox' and
why that is happening. Any ideas or I will get more specific. I am using many .controlsource and mulitpage form. Thanks. Sub TextBox24_Change() Dim Ctrl as Control For Each Ctrl In UserForm20.Controls If TypeOf Ctrl Is MSForms.textbox Then For i = 25 To 30 If Ctrl.Name = "TextBox" & i Then Ctrl.Value = TextBox24.Value End If Next i End If Next End Sub John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop based on number entered in userform | Excel Worksheet Functions | |||
| Loop through userform | Excel Discussion (Misc queries) | |||
| Need a macro to loop evaluation of many textboxes in a UserForm. | Excel Programming | |||
| Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
| Using For/Next Loop To Generate 4 CommandButtons On A UserForm Results In A Runtime Error 91 | Excel Programming | |||
Threaded Mode
